DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Urgent.... ORA 02429

  1. #1
    Join Date
    May 2002
    Posts
    163
    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width