QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

Cause: A stale materialized view cannot be used for query rewrite when the query rewrite integrity mode is set to TRUSTED.

Action: Refresh the materialized view or alter the rewrite integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY = STALE TOLERATED command.

No comments:

Post a Comment