| dropping index tablespace [message #351100] |
Mon, 29 September 2008 05:02  |
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  |
 |
Michel Cadot
Messages: 68666
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
