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-00480: LCK* process terminated with error

1 Answers  


ORA-00601: cleanup lock conflict

1 Answers  


ORA-30364: this level has the same set of columns as another

1 Answers  


ORA-25007: functions or methods not allowed in WHEN clause

1 Answers  


ORA-15125: ASM file name 'string' contains an invalid template name

1 Answers  






ORA-25442: too many column values for table alias: string

1 Answers  


ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.

1 Answers  


ORA-00701: object necessary for warmstarting database cannot be altered

1 Answers  


LFI-00148: %s can be called only on files opened in byte mode

1 Answers  


PLS-00900: can't find body of unit 'string'

1 Answers  


ORA-25472: maximum open iterators exceeded

1 Answers  


NNL-00890: Messages received: number

1 Answers  


Categories