| ERROR | referential integrity constraint on table, string, not VALID in ENFORCED integrity mode |
| CAUSE | A join present in the materialized view requires validated primary/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. |