Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode
- 1 Answers
- 3116 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 |
DRG-11871: WAIS Server Doesn't Return Any Data
ORA-01921: role name 'string' conflicts with another user or role name
ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file
ORA-23360: only one materialized view for master table "string" can be created
ORA-27086: unable to lock file - already in use
NZE-29100: Cannot create local key ID.
ORA-02851: Request list is empty when it should not be
ORA-22163: left hand and right hand side collections are not of same type
TNS-00286: Max Connect Time (secs) : number
ORA-32051: mapping service not available
ORA-12923: tablespace string is in force logging mode
PLS-01470: The escape character in the like-predicate must be a literal or a variable of type CHAR
Oracle Errors 
