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-01643: system tablespace can not be made read only

1 Answers  


ORA-06722: TLI Driver: connection setup failure

1 Answers  


ORA-24364: internal error while padding blanks

1 Answers  


ORA-29538: Java not installed

1 Answers  


ORA-28293: No matched Kerberos Principal found in any user entry

1 Answers  






ORA-25216: invalid recipient, either NAME or ADDRESS must be specified

1 Answers  


ORA-26563: renaming this table is not allowed

1 Answers  


ORA-25102: PARALLEL option can only be used with ALTER INDEX REBUILD

1 Answers  


PCB-00110: Unable to open temporary file "string"

1 Answers  


ORA-38734: Flashback log is inconsistent; belongs to another database.

1 Answers  


ORA-31642: the following SQL statement fails: string

1 Answers  


ORA-19773: must specify change tracking file name

1 Answers  


Categories