ORA-02442: Cannot drop nonexistent unique key



ORA-02442: Cannot drop nonexistent unique key..

Answer / guest

Cause: alter table drop unique (<col list>) - unique
specification does not exist.

Action: make sure column list for unique constraint is correct.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.

1 Answers  


ORA-39314: illegal sync_code() call: only applys after clone/sync_code

1 Answers  


SQL*Loader-00901: Error logging on to ORACLE:

1 Answers  


DRG-12011: Authentication failed - retry?

1 Answers  


ORA-22861: invalid user-defined type

1 Answers  






ORA-13137: failed to generate tablespace sequence number

1 Answers  


ORA-32505: too many watchpoints

1 Answers  


ORA-19862: backup pieces must be validated before accessing results

1 Answers  


TNS-02510: Invalid numeric data type

1 Answers  


ORA-23309: object string.string of type string exists

1 Answers  


ORA-03222: average row size and row count must be greater than zero

1 Answers  


ORA-12069: invalid object for offline instantiation

1 Answers  


Categories