QSM-01030: materialized view, string, has PL or SQL functions in ENFORCED integrity mode

QSM-01030: materialized view, string, has PL or SQL functions in ENFORCED integrity mode

Cause: A materialized view with PL or SQL functions in its definition cannot be used for query rewrite when query rewrite integrity is set to ENFORCED.

Action: Consider running the query in STALE TOLERATED mode.

No comments:

Post a Comment