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

NNO-00053: duplicate domain description for domain "string"

1 Answers  


ORA-12600: TNS: string open failed

1 Answers  


DRG-10839: invalid ORDER argument supplied to NEAR

1 Answers  


ORA-19665: size string in file header does not match actual file size of string

1 Answers  


ORA-19756: corrupt block number string found in change tracking file

1 Answers   Scope International,


ORA-38709: Recovery Area is not enabled.

3 Answers  


IMP-00020: long column too large for column buffer size (number)

1 Answers  


EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help

1 Answers  


ORA-31222: DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.

1 Answers  


ORA-16815: incorrect log transport setting for AlternateLocation of standby "string"

1 Answers  


ORA-26714: User error encountered while applying

3 Answers  


ORA-32143: Environment not specified

1 Answers  


Categories