Home » RDBMS Server » Server Administration » dropping index tablespace (Oracle 9iR2 RHEL4)
dropping index tablespace [message #351100] Mon, 29 September 2008 05:02 Go to next message
Messages: 2
Registered: September 2008
Junior Member

My database runs in noarchivelog. I had to restore a backup last week and one datafile was missing. It is a datafile from a tablespace that contains only indexes.

I put the datafile offline to allow startup, now I am wondering how to safely drop the tablespace, recreate it and recreate all the indexes. I am mostly worried about primary keys.

I have a full export of the database structure (no rows).

What are the correct steps to recreate all indexes properly without breaking constraints ?

Monique Petit
Re: dropping index tablespace [message #351102 is a reply to message #351100] Mon, 29 September 2008 05:08 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
now I am wondering how to safely drop the tablespace

You have no other solution to get a clean database, you have to drop or disable all unique and primary constraints and drop all indexes and recreate them.


Previous Topic: ORA-00600
Next Topic: Roolback Segment
Goto Forum:

Current Time: Sat Oct 22 17:07:14 CDT 2016

Total time taken to generate the page: 0.10664 seconds