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
mpetit
Messages: 2
Registered: September 2008
Junior Member
Hi,

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 ?

Sincerly,
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: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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.

Regards
Michel

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


Current Time: Tue Dec 06 12:37:13 CST 2016

Total time taken to generate the page: 0.20105 seconds