首页 > Linux操作系统 > Linux操作系统 > DDL Parameters

DDL Parameters

原创 Linux操作系统 作者:chncaesar 时间:2013-09-25 11:18:07 0 删除 编辑
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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量