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-02713: osnprd: message receive failure

1 Answers  


ORA-39111: Dependent object type string skipped, base object type string already exists

1 Answers  


QSM-02002: DISTINCT aggregate measure in SELECT list

1 Answers  


ORA-36986: (XSRELGID05) Relation workspace object must be dimensioned by workspace object.

1 Answers  


ORA-23353: deferred RPC queue has entries for object group "string"."string"

1 Answers  






ORA-19681: block media recovery on control file not possible

1 Answers  


TNS-01304: ns secondary err code: number

1 Answers  


RMAN-06498: skipping datafile string; already backed up string time(s)

1 Answers  


RMAN-05515: Duplicate for standby does not allow the use of SET UNTIL

1 Answers  


ORA-04007: MINVALUE cannot be made to exceed the current value

1 Answers  


ORA-13761: invalid filter

1 Answers  


ORA-07403: sfanfy: db_writers parameter not valid.

1 Answers  


Categories