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
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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Drop and recreate it.
Or simply drop all users.

Regards
Michel
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
Previous Topic: Memory leak after upgrading 9.2.0.4 to 10.2.0.4
Next Topic: Transaction Tracer in Oracle
Goto Forum:
  


Current Time: Sun Dec 01 17:12:22 CST 2024