December 2002
Intermediate to advanced
928 pages
85h 29m
English
QUERY_REWRITE_INTEGRITY
Value: STALE_TOLERATED | TRUSTED | ENFORCED
Default: ENFORCED
Dynamic: ALTER SYSTEM, ALTER SESSION
Specifies the degree to which Oracle will enforce query rewriting.
Allows rewrites using unenforced relationships. Materialized views may be rewritten even if they are known to be inconsistent with underlying detail data.
Allows rewriting using relationships that have been declared but not enforced by Oracle.
Oracle enforces and guarantees consistency and integrity.