Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can't drop tablespace

user187147Mar 31 2011 — edited Mar 31 2011
Oracle 10.24
Solaris 10.5 SPARC 64bits

I am trying to drop a tablespace I created to resize my original tablespace, but getting the following error:
SQL> drop tablespace backup_ts including contents and datafiles cascade constraints;
drop tablespace backup_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
I have also remove all the tables from this tablespace (backup_ts) and still getting error.
This post has been answered by ji li on Mar 31 2011
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 28 2011
Added on Mar 31 2011
#general-database-discussions
5 comments
920 views