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-07490: scgrcl: cannot convert lock.

1 Answers  


ORA-29951: warning in the execution of ODCIINDEXSPLITPARTITION routine

1 Answers  


PCC-02364: Host struct and its indicator must have the same number of fields

1 Answers  


DRG-50703: listener startup error

1 Answers  


ORA-31503: invalid date supplied for begin_date or end_date

1 Answers  






ORA-29526: created Java class string"string"

1 Answers  


ORA-26017: global indexes not allowed for direct path load of table partition string

1 Answers  


ORA-19665: size string in file header does not match actual file size of string

1 Answers  


ORA-19209: invalid or unsupported formatting argument

1 Answers  


PROC-00105: Logging error

1 Answers  


ORA-16779: The destination parameter of some database has wrong syntax.

1 Answers  


ORA-14016: underlying table of a LOCAL partitioned index must be partitioned

1 Answers  


Categories