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-25466: data not specified for variable name: string

1 Answers  


ORA-31637: cannot create job string for user string

1 Answers  


RMAN-06600: old RMAN configuration parameters:

1 Answers  


PCC-02328: undefined struct member

1 Answers  


LFI-01002: Unable to read line from file.

1 Answers  


QSM-02052: subquery using a select list in mv

1 Answers  


ORA-06126: NETTCP: ORASRV unable to open network connection

1 Answers  


ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD

1 Answers  


ORA-29829: implementation type does not exist

1 Answers  


ORA-38612: FI item length cannot exceed half of one database block.

1 Answers  


ORA-03250: Cannot mark this segment corrupt

1 Answers  


ORA-32311: materialized view definition query selects an unsupported user-defined type

1 Answers  


Categories