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

QSM-00757: the specified workload string is not referenced by task string

1 Answers  


ORA-03123: operation would block

1 Answers  


RMAN-06533: KEEP ... NOLOGS option is not supported when database is open

2 Answers  


ORA-25117: MIN/MAX/Block Number expected

1 Answers  


TNS-01067: Service display mode is string

1 Answers  






ORA-13781: The tuning task does not exist.

1 Answers  


TNS-12570: TNS:packet reader failure

1 Answers  


ORA-02269: key column cannot be of LONG datatype

2 Answers  


ORA-16550: truncated result

1 Answers  


ORA-04051: user string cannot use database link string.string

1 Answers  


QSM-02123: subquery and UNION mv's must be primary key mv's

1 Answers  


QSM-01115: rollup took place on a column with a window function

1 Answers  


Categories