ORA-02429: cannot drop index used for enforcement of
unique/primary key



ORA-02429: cannot drop index used for enforcement of unique/primary key..

Answer / guest

Cause: user attempted to drop an index that is being used as
the enforcement mechanism for unique or primary key.

Action: drop the constraint instead of the index.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12596: TNS:internal inconsistency

1 Answers  


ORA-14619: resulting List subpartition(s) must contain at least 1 value

1 Answers  


ORA-01525: error in renaming data files

1 Answers  


TNS-12520: TNS:listener could not find available handler for requested type of server

1 Answers  


ORA-19002: Missing XMLSchema URL

1 Answers  






O2I-00133: An error occurred for which no message is available

1 Answers  


ORA-23538: cannot explicitly refresh a NEVER REFRESH materialized view ("string")

1 Answers  


ORA-16058: standby database instance is not mounted

1 Answers  


PLS-00169: modifier 'string' conflicts with prior 'string' specification

1 Answers  


ORA-22902: CURSOR expression not allowed

1 Answers  


ORA-26530: unable to build materialized view refresh control list

1 Answers  


QSM-02051: subquery using the NOT EXISTS clause in mv

1 Answers  


Categories