I have table called TEST , it has attributes a ,b and c.
a is primary key.
I have created an index IND_TEST_01 on (a,b). Other two tables have foreign key reference to this table.
when I am droping the index IND_TEST_01 , I am getting the following error.
ORA-02429 cannot drop index used for enforcement of unique/primary key.
But just to check the same, when I am creating a temporary table to check the same, with same configuration I can delete the index.
What is the reason, why it is not allowing me to drop the index?
Pls. give me some possible reasons.
It is the first index that is created which is chosen to enforce the unique constraints.
Drop the constraint, not the index.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
Click Here to Expand Forum to Full Width