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-30378: MV_CAPABILITIES_TABLE is not compatible with Oracle version

1 Answers  


QSM-01087: query grouping on a column that cannot be derived from materialized view, string

1 Answers  


ORA-01303: subordinate process error: number. Check alert and trace logs

1 Answers  


TNS-12557: TNS:protocol adapter not loadable

2 Answers  


RMAN-08121: keep attributes for the backup are deleted

1 Answers  






PCC-00078: FIPS warning: Invalid ANSI SQL Identifier

1 Answers  


DRG-10820: invalid contains cursor id

1 Answers  


RMAN-02005: token too big

2 Answers  


ORA-23377: bad name string for missing_rows_oname1 argument

1 Answers  


NCR-01011: NCRS: Send message failure.

1 Answers  


ORA-02882: sou2o: Could not register SGA for protection

1 Answers  


DGM-16952: unable to describe configuration

1 Answers  


Categories