-
Hi everybody,
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.
Regards
Nwcomer
Student
-
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,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|