Modify unique constraint in Oracle Modify unique constraint in Oracle sql sql

Modify unique constraint in Oracle


You should drop and recreate the constraint. modify constraint allows you to change constraint's state not definition.

See: Oracle Docs