Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode
- 1 Answers
- 3039 Views
- I also Faced
- E-Mail Answers
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 |
ORA-10563: Test recovery had to corrupt data block (file# string, block# string) in order to proceed
NNL-00003: memory exhausted
TNS-00105: Could not initialize tracing
O2I-00119: Warning reported by subsystem:
ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT and NTEXT.
LPX-00256: invalid element declaration
NNL-01078: Access/Create File Error : string
ORA-06313: IPA: Shared memory failed to initialise
ORA-16954: SQL parse error.
ORA-01243: system tablespace file suffered media failure
ORA-24019: identifier for string too long, should not be greater than string characters
ORA-12011: execution of string jobs failed
Oracle Errors 
