ENABLE VALIDATE:
1、对现有数据检查约束。如果有违反约束限制的,则约束不能建立/启用。
2、启用约束。
3、对新插入数据检查约束。如果有违反约束限制的数据,将不能插入。
specifies that all old and new data also complies with the constraint. An enabled validated constraint guarantees that all data is and will continue to be valid.

ENABLE NOVALIDATE:
1、对现有数据不检查约束。
2、启用约束。
3、对新插入数据检查约束。如果有违反约束限制的数据,将不能插入。
ensures that all new DML operations on the constrained data comply with the constraint. This clause does not ensure that existing data in the table complies with the constraint and therefore does not require a table lock.

DISABLE VALIDATE:(还不能很准确的说好,先把原话放上来吧)
disables the constraint and drops the index on the constraint, but keeps the constraint valid. This feature is most useful in data warehousing situations, because it lets you load large amounts of data while also saving space by not having an index. This setting lets you load data from a nonpartitioned table into a partitioned table using the exchange_partition_clause of the ALTER TABLE statement or using SQL*Loader. All other modifications to the table (inserts, updates, and deletes) by other SQL statements are disallowed.

DISABLE NOVALIDATE:
1、约束不起作用
2、无法保证约束是真实的(不对任何数据做约束检查)
signifies that Oracle makes no effort to maintain the constraint (because it is disabled) and cannot guarantee that the constraint is true (because it is not being validated).