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

ORA-26571: %s.string.string: number of arguments (string) does not match replication catalog

1 Answers  


TNS-01413: "string" established:string refused:string current:string max:string state:string

1 Answers  


NZE-29135: Seed generation for Random Number Generator failed.

1 Answers  


VID-00714: internal error

1 Answers  


ORA-29507: query derived from USING clause found zero or many rows

1 Answers  






NZE-29232: the cryptographic engine key initialization failed

1 Answers  


ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.

1 Answers  


ORA-40004: penalty must be negative for BLAST-N

1 Answers  


QSM-00779: the specified directive conflicts with the existing directive string

1 Answers  


ORA-14259: table is not partitioned by Hash method

1 Answers  


PLS-00337: "string" matches too many object table aliases

1 Answers  


TNS-02516: No data available

1 Answers  


Categories