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-29829: implementation type does not exist

1 Answers  


ORA-30679: JDWP-based debugging not supported in this configuration

1 Answers  


QSM-02177: MV with UNION ALL in a view must match the view's SELECT list

1 Answers  


SQL*Loader-00401: End field position number must be greater than or equal to start number

1 Answers  


O2I-00121: No value was specified for the CODE option

1 Answers  


ORA-31519: CDC subscription string already exists

1 Answers  


ORA-24421: OCISessionRelease cannot be used to release this session.

1 Answers  


NNL-00502: Shows, sets, or cancels when the server next dumps its statistic counters

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  


KUP-04002: error getting file size for file string

1 Answers  


ORA-32816: foreign queue string is referenced by a subscriber or schedule

1 Answers  


ORA-23611: tablespace "string" has more than one data file

1 Answers  


Categories