Disable a Unique Constraint in Oracle
If this post helps you, click an ad
A unique constraint is used to ensure that a singular value occur only once in a column or that a distinctive combination of values occur only once across a series of columns.
A unique constraint in Oracle can be disabled using the following syntax:
ALTER TABLE my_table DISABLE CONSTRAINT my_constraint;
Tags: constraints, disable, SQL, unique