Disable Validate
1. ENABLE VALIDATE specifies that all old data also complies with the
constraint along with the new ones. An enabled validated constraint
guarantees that all data is and will continue to be valid.
2. ENABLE NOVALIDATE ensures that all new DML operations on the constrained
data comply with the constraint, but does not ensure that existing data
in the table complies with the constraint.
Oracle Constraints
Types of Constraints
Constraint Description
NOT NULL : Specifies that a column cannot contain null values
UNIQUE : Designates a column or combination of columns as unique
PRIMARY KEY : Designates a column or combination of columns as the table’s primary key
FOREIGN KEY : Designates a column or combination of columns as the foreign key in a referential integrity constraint
CHECK : Specifies a condition that each row of the table must satisfy
