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.
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.
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.