ORA-02439: Unique index on a deferrable constraint is not allowed

ORA-02439: Unique index on a deferrable constraint is not allowed


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.