Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode
- 1 Answers
- 3082 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-31618: dump file size too small
LSX-00248: invalid duration "~S"
ORA-31506: duplicate subscription name string
ORA-24312: illegal parameters specified for allocating user memory
ORA-04002: INCREMENT must be a non-zero integer
ORA-19690: backup piece release string incompatible with Oracle release string
ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
PROT-00807: Please ensure you have file creation privileges in the executing directory before running this tool.
ORA-27489: unable to process job "string.string" from job class "string"
PCC-00075: ":" expected before indicator variable
RMAN-20241: ambiguous archived log name
ORA-31642: the following SQL statement fails: string
Oracle Errors 
