Skip to Main Content
Forums

SQL & PL/SQL

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 without any object

wandy8424Oct 18 2017 — edited Oct 19 2017

when I tried to drop a tablespace，I got there orror：

SQL> purge recyclebin

Recyclebin purged.

SQL> select owner,segment_name,tablespace_name from   dba_segments where tablespace_name='DATA_TBS';

no rows selected

SQL> drop tablespace DATA_TBS 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

Thanks
This post has been answered by SeánMacGC on Oct 18 2017
Jump to Answer

Comments

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

Post Details

Locked on Nov 16 2017
Added on Oct 18 2017
16 comments
1,201 views