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

PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

1 Answers  


AMD-00126: dimension #string: analytic workspace column level relation not specified

1 Answers  


ORA-01583: unable to get block size of controlfile to be backed up

1 Answers  


ORA-10573: Test recovery tested redo from change string to string

1 Answers  


TNS-00249: Unable to read network configuration data from file string with error: string

1 Answers  






PROC-00101: Operating System error [string]

1 Answers  


ORA-08116: can not acquire dml enough lock(S mode) for online index build

1 Answers  


ORA-29811: missing STATISTICS keyword

1 Answers  


NPL-00312: attempt to put ASN.1 "UNIV" type with illegal tag string

1 Answers  


ORA-29809: cannot drop an operator with dependent objects

1 Answers  


TNS-04231: Trace Assistant WARNING: Assuming Oracle trace format

1 Answers  


NNL-00574: dump_tnsnames [<file>] : dump ONames addresses into tnsnames file

1 Answers  


Categories