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-13601: The specified Advisor string does not exist.

1 Answers  


ORA-14313: Value string does not exist in partition string

1 Answers  


DRG-10755: %(1)s and string have characters in common

1 Answers  


KUP-01007: at line number column number

1 Answers  


ORA-28575: unable to open RPC connection to external procedure agent

1 Answers  






LFI-00114: Append is not allowed with string.

1 Answers  


ORA-25532: MTTR specified is too large: string

1 Answers  


ORA-08261: ora_addr: cannot find name in nameserver

1 Answers  


ORA-00099: timed out while waiting for resource, potential PDML deadlock

1 Answers  


IMG-00857: area list free failed

1 Answers  


ORA-38605: FI not enough memory(stringK) for candidate generation(stringK)

1 Answers  


QSM-00514: the size of must-retain summaries exceeds specified space limit

1 Answers  


Categories