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-02478: merge into base segment would overflow MAXEXTENTS limit

1 Answers  


ORA-09270: szalloc: error allocating memory for security

1 Answers  


ORA-12629: TNS:no event test

1 Answers  


ORA-07222: slspool: line printer spooler command exited with an error.

1 Answers  


LCD-00209: missing value for keyword at end of string [string]

1 Answers  






DRG-12016: The target document for this operation has moved - continue?

1 Answers  


ORA-23410: materialized view "string"."string" is already in a refresh group

1 Answers  


ORA-26666: cannot alter STREAMS process string

1 Answers  


ORA-25530: FAST_START_MTTR_TARGET is not specified

1 Answers  


ORA-24123: feature string is not yet implemented

1 Answers  


ORA-29258: buffer too small

1 Answers  


ORA-01313: LogMiner dictionary column type different from specified type

1 Answers  


Categories