Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.