Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01029: materialized view, string, is stale in ENFORCED
integrity mode
- 1 Answers
- 4545 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
ENFORCED.
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 ? | 1 Yes | 0 No |
ORA-38763: flashback not started; enabled threads have changed
ORA-30162: The OCIFile context is not initialzed
SQL*Loader-00259: Could not escalate DDL share lock to exclusive on table string
ORA-01232: cannot start online backup - file string is being made read-only
PLS-00235: the external type is not appropriate for the parameter
NNC-00410: invalid preferred server address list
QSM-01050: roll-up check failed for materialized view, string
ORA-30160: Unable to access the file
RMAN-08022: channel string: restoring archive log
ORA-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.
RMAN-08516: controlfile copy filename=string recid=string stamp=string
ORA-00217: controlfile could not be resized for migration from 9.0.1
Oracle Errors 
