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!

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,629 views