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.

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
#general-database-discussions
18 comments
2,125 views