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;
