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

EXP-00054: error on row number of subpartition string

1 Answers  


ORA-25329: AQ array operations not allowed on 8.0 queues

1 Answers  


SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string

1 Answers  


ORA-06976: X.25 Driver: endpoint creation failure

1 Answers  


ORA-33052: (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.

1 Answers  






ORA-38768: resizing datafile string failed

1 Answers  


ORA-03132: two-task default value overflow

1 Answers  


ORA-22290: operation would exceed the maximum number of opened files or LOBs

1 Answers  


LSX-00124: "list" element is improperly defined

1 Answers  


NID-00450: Succesfully changed database name and ID.

1 Answers  


ORA-01181: file string created before last known RESETLOGS, cannot recreate

1 Answers  


ORA-06322: IPA: Fatal shared memory error

1 Answers  


Categories