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-27084: unable to get/set file status flags

1 Answers  


TNS-00503: Illegal ADDRESS parameters

1 Answers  


ORA-31002: Path name string is not a container

1 Answers  


ORA-01409: NOSORT option may not be used; rows are not in ascending order

1 Answers  


RMAN-06128: skipping inaccessible file string

1 Answers  


TNS-00551: underlying transport connection failed

1 Answers  


ORA-01031: insufficient privileges

1 Answers  


NNL-00856: Average rename processing time: string

1 Answers  


ORA-37116: OLAP API table function error: (string)

1 Answers  


ORA-14257: cannot move partition other than a Range or Hash partition

1 Answers  


LRM-00117: syntax error at 'string' at the start of input

1 Answers  


ORA-14078: you may not drop the highest partition of a GLOBAL index

1 Answers  


Categories