Enable --> Incoming data
Validate --> Existing data
Rely --> For query rewrite. Specify RELY to activate an existing constraint in NOVALIDATE mode for query rewrite in an unenforced query rewrite integrity mode.
1. Defers constraint check to the end of the transaction. This is helpful in cases where parent-child records are to be inserted into tables with FK enabled.
2. Defers segment creation.
3. Materialized View Build Deferred: The MV is not available for query rewrite until the first complete refresh. Hence, the first complete refresh populates the MV. On the other hand, a build-immediate MV implicitly includes a complete refresh upon creation.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/638844/viewspace-773336/，如需转载，请注明出处，否则将追究法律责任。