| lost index files [message #56351] |
Mon, 24 March 2003 08:31  |
pb
Messages: 18
Registered: December 2000
|
Junior Member |
|
|
i've lost one disk that contents only
may index file. i've no backup . I'd like to drop
the tablespace including contents and after i'll create a new index tablespace. but i get
RA-00604: error occurred at recursive SQL level 1
ORA-02429: cannot drop index used for enforcement of unique/primary key
this is my query :drop tablespace CALL_INDEX including contents ;
please can you help me
|
|
|
|
| Re: lost index files [message #56352 is a reply to message #56351] |
Mon, 24 March 2003 08:56  |
JUAN
Messages: 23
Registered: November 2000
|
Junior Member |
|
|
Hi, to drop the tablespace you must disable the primary keys of tables.
alter table xxx disable primary key cascade;
Be sure that your tablespace is offline before you drop it.
After recreate the index tablespace you must enable the primary keys and foreing keys constraints.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
