So I know this disables the constraint. What does the vallidate part do?
Validates that existing data still adheres to the constraint (doesn't seem needed), or does it validate incoming data still conforms to the constraint (then why would you disable the constraint..).
Wondering what the use of disable validate does.
I know disable novalidate is the default, same as disable, which basically simply disables the constraint.
an example:
alter table table_1 DISABLE VALIDATE primary key ;