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-01614: instance string (thread string) is busy - cannot enable

1 Answers  


ORA-01110: data file string: 'string'

1 Answers  


ORA-13851: Tracing for client identifier string is already enabled

1 Answers  


ORA-23348: cannot replicate procedure string; only IN parameters supported

1 Answers  


ORA-30394: source statement identical to the destination statement

1 Answers  


TNS-12696: Double Encryption Turned On, login disallowed

1 Answers  


ORA-28543: Error initializing apply connection to non-Oracle system

1 Answers  


RMAN-12011: multiple records for default device type found in catalog

1 Answers  


DRG-11113: value of string must be one of string

1 Answers  


EXP-00012: %s is not a valid export mode

1 Answers  


ORA-27076: unable to set limit for open files

1 Answers  


ORA-09934: Link of current password file to old failed.

1 Answers  


Categories