Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode
- 1 Answers
- 3188 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-36704: (XSRELTBL06) workspace object should be dimensioned by workspace object.
ORA-23304: malformed deferred rpc at arg string of string in call string, in tid string
IMP-00045: using VOLSIZE value from export file of string
PCC-02391: Runtime context variable not of correct type
ORA-23372: type string in table string is unsupported
PLS-00456: item 'string' is not a cursor
ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management
LCD-00201: could not open specified filename [string]
NZE-28785: parameter does not exist
ORA-29316: datafile string been imported twice
DRG-12515: cannot specify language for stopwords in a BASIC_STOPLIST
ORA-13825: missing SQL statement text for create SQL profile
Oracle Errors 
