Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

TNS-00229: Error in call: unable to deliver message :string: string string string

1 Answers  


ORA-30386: invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE

1 Answers  


ORA-13447: GeoRaster metadata BRS error

1 Answers  


TNS-03501: OK

1 Answers  


ORA-29286: internal error

1 Answers  






ORA-15005: name "string" is already used by an existing alias

1 Answers  


IMP-00051: Direct path exported dump file contains illegal column length

1 Answers  


ORA-13330: invalid MASK

1 Answers  


ORA-12201: TNS:encountered too small a connection buffer

1 Answers  


ORA-25185: index column other than last can not be specified for INCLUDE clause

1 Answers  


ORA-21700: object does not exist or is marked for delete

1 Answers  


ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

1 Answers  






Categories