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!

Drop Tablespace

user11979518May 26 2010 — edited May 27 2010
Hi Guys...

I am using Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production on Solaris.

I moved datafiles while the tablespace is online accidentally so.

Now I want to drop the said tablespace and recreate it...

But when I issue:

DROP TABLESPACE INDEX1 INCLUDING CONTENTS AND DATAFILES;

I get the fowolling error:

*
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

How can I get the index that is causing this issues or how can I resolve this iussue?

Thanks in advance.
This post has been answered by Chinar on May 27 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2010
Added on May 26 2010
18 comments
2,218 views