QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode
Cause: A join present in the materialized view requires validated primary or foreign key constraints in ENFORCED query rewrite integrity mode.
Action: Validate the constraint or change the integrity mode with ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED command.
Cause: A join present in the materialized view requires validated primary or foreign key constraints in ENFORCED query rewrite integrity mode.
Action: Validate the constraint or change the integrity mode with ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED command.
No comments:
Post a Comment