Oracle database error code ORA-02439 – Unique index on a deferrable constraint is not allowed

Oracle Database Error Code ORA-2439 Description :
Unique index on a deferrable constraint is not allowed
Error Cause:
attempted to enable a deferrable primary key/unique constraint that has an existing unique index on the constraint columns.

How to Solve :
Drop the index on the constraint columns or make the constraint not deferrable.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»