约束的状态enable validate的组合

特别是ENABLE NOVALIDATE；可以不计前嫌，不验证之前的数据

Constraint States
■ ENABLE ensures that all incoming data conforms to the constraint
■ DISABLE allows incoming data, regardless of whether it conforms to the
constraint
■ VALIDATE ensures that existing data conforms to the constraint
■ NOVALIDATE means that some existing data may not conform to the constraint

In addition:
■ ENABLE VALIDATE is the same as ENABLE. The constraint is checked and is
guaranteed to hold for all rows.
■ ENABLE NOVALIDATE means that the constraint is checked, but it does not have to
be true for all rows. This allows existing rows to violate the constraint, while
ensuring that all new or modified rows are valid.
In an ALTER TABLE statement, ENABLE NOVALIDATE resumes constraint checking
on disabled constraints without first validating all data in the table.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/70612/viewspace-1024100/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/70612/viewspace-1024100/