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-32580: both SYS and SYSTEM passwords must be provided

1 Answers  


TNS-12520: TNS:listener could not find available handler for requested type of server

1 Answers  


ORA-19657: cannot inspect current datafile string

1 Answers  


ORA-30197: reserved for future use

1 Answers  


ORA-01239: database must be in ARCHIVELOG mode to use external cache

1 Answers  


ORA-12539: TNS:buffer over- or under-flow

1 Answers  


TNS-12546: TNS:permission denied

2 Answers  


QSM-02063: aggregate function in mv

1 Answers  


PLS-00411: Number of values in aggregate and in subquery don't match

1 Answers  


ORA-02791: Unable to open file for use with asynchronous I/O

1 Answers  


RMAN-06540: tablespace string will be excluded from future whole database backups

1 Answers  


ORA-14408: partitioned index contains subpartitions in a different tablespace

1 Answers  


Categories