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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11727: phrase does not have any related terms

1 Answers  


ORA-04087: cannot change the value of ROWID reference variable

1 Answers  


ORA-07682: sou2os: set kernel dispatch fail err

1 Answers  


ORA-01632: max # extents (string) reached in index string.string

1 Answers  


PLS-00206: %%TYPE must be applied to a variable, column, field or attribute, not to "string"

1 Answers  






ORA-12433: create trigger failed, policy not applied

1 Answers  


ORA-22061: invalid format text [string]

1 Answers  


ORA-01573: shutting down instance, no further change allowed

1 Answers  


ORA-01103: database name 'string' in controlfile is not 'string'

4 Answers  


PLS-00537: A VARRAY must have a positive limit

1 Answers  


IMG-00578: missing quantize argument

1 Answers  


ORA-24369: required callbacks not registered for one or more bind handles

1 Answers  


Categories