dropping index tablespace [message #351100] |
Mon, 29 September 2008 05:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 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
|
|
|