Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-02439: Unique index on a deferrable constraint is not
allowed



ORA-02439: Unique index on a deferrable constraint is not allowed..

Answer / guest

Cause: attempted to enable a deferrable primary key/unique
constraint that has an existing unique index on the
constraint columns.

Action: Drop the index on the constraint columns or make the
constraint not deferrable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38312: original name is used by an existing object

3 Answers  


PCC-00120: File I/O error during code generation

1 Answers  


ORA-31402: unrecognized parameter string

1 Answers  


RMAN-08059: media recovery failed

1 Answers  


NNO-00056: warning: domain minimum TTL must be between number and number, set to number seconds

1 Answers  






ORA-13353: ELEM_INFO_ARRAY not grouped in threes

1 Answers  


ORA-28025: missing or null external name

1 Answers  


TNS-01408: Instance "string", status string, has string handler(s) for this service...

1 Answers  


PLS-00536: Navigation through REF variables is not supported in PL/SQL.

1 Answers  


RMAN-06593: platform name 'string' specified in FROM PLATFORM is not valid

1 Answers  


LSX-00026: unknown attribute "~S"

1 Answers  


ORA-01029: internal two task error

1 Answers  






Categories