Oracle DBA, How To, Error, Cause and Action

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.