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

RMAN-03099: job cancelled at user request

1 Answers  


ORA-01912: ROW keyword expected

1 Answers  


ORA-16547: cannot disable the primary database

1 Answers  


ORA-04083: invalid trigger variable 'string'

1 Answers  


RMAN-08551: recovering datafilecopy fno=string name=string

1 Answers  


LSX-00020: unknown type "~S"

1 Answers  


ORA-13261: geometry table string does not exist

1 Answers  


ORA-00349: failure obtaining block size for 'string'

1 Answers  


ORA-02459: Hashkey value must be a positive integer

1 Answers  


ORA-16578: failed to read Data Guard configuration file

1 Answers  


ORA-31094: incompatible SQL type "string" for attribute or element "string"

1 Answers  


LFI-01001: Unable to write string bytes to file.

1 Answers  


Categories