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 remove index ORA-02429:

scottf76Aug 6 2008 — edited Aug 6 2008
Hello,
I have been trying to remove an index on a table with error ->

drop index INDEX_NAME
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key

This index has nothing to do with any unique or primary key. I believe the problem maybe that the index is the IOT for the table. I have removed the associated constraint but this does not help. Any ideas? Is there a way to rebuild the table with another IOT?

thanks.

Comments

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

Post Details

Locked on Sep 3 2008
Added on Aug 6 2008
#general-database-discussions
1 comment
1,573 views