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-19209: invalid or unsupported formatting argument

1 Answers  


ORA-32308: object materialized views must use SELECT *

1 Answers  


SQL*Loader-00628: Character set conversion error.

1 Answers  


ORA-14159: duplicate subpartition name

1 Answers  


SQL*Loader-00458: Comparison text ('string') of CONTINUEIF LAST must be non-whitespace

1 Answers  


QSM-00512: invalid summaries specified in the retention-list

1 Answers  


ORA-00704: bootstrap process failure

1 Answers  


TNS-02515: Encryption/crypto-checksumming: unknown control type

1 Answers  


ORA-09352: Windows 32-bit Two-Task driver unable to spawn new ORACLE task

1 Answers  


ORA-12208: TNS:could not find the TNSNAV.ORA file

1 Answers  


LPX-00268: invalid access method ~1d, must be 0 to ~2d

1 Answers  


ORA-01861: literal does not match format string

1 Answers  


Categories