Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to drop tablespace ...!!!

633045Jun 17 2008 — edited Jul 1 2008
we have got a TEST database where data is not so important. now there is a requirement to drop a tablespace but it has got referenced tables
in another tablespaces.. inspite of giving CASCADE CONSTRAINTS its not working. following error is thrown..

SQL> drop tablespace INTER_TS including contents and datafiles cascade constraints;
drop tablespace INTER_TS including contents and datafiles cascade constraints
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-02429: cannot drop index used for enforcement of unique/primary key


please help... my requirement is anyhow i've to delete the tablespace INTER_TS.

regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2008
Added on Jun 17 2008
10 comments
1,904 views