Home » RDBMS Server » Server Administration » Reset database (merged)
Reset database (merged) [message #415473] Tue, 28 July 2009 00:55 Go to next message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Dear All

I have installed oracle database into my computer and created ten users and import data accordingly without any proper storage parameters like tablespace and datafile.Now i am afraid that all users data are using system tablespace.Now i want to reset my database to its original position and then create tablespaces like separate user tablespace ,undo tablespace and datafiles, kindly guide me.

Regards


Zuhair

Report message to a moderator

Re: Reset database (merged) [message #415479 is a reply to message #415473] Tue, 28 July 2009 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop and recreate it.
Or simply drop all users.

Regards
Michel

Report message to a moderator

Re: Reset database (merged) [message #415484 is a reply to message #415473] Tue, 28 July 2009 01:31 Go to previous message
gozuhair
Messages: 206
Registered: January 2008
Senior Member
Thanks,will drop it

Report message to a moderator

Previous Topic: Memory leak after upgrading 9.2.0.4 to 10.2.0.4
Next Topic: Transaction Tracer in Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 08:31:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.