QSM-01099: non-tolerated reference to stale portion of mv
for table string
- 1 Answers
- 2189 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The materialized view is partially stale. It is stale
with respect to one or more partitions in one or more of its
detail tables. The request query references one or more such
detail partitions.
Action: (1) Change the selection criteria of the request to
restrict the query to only the fresh portion of the
materialized view, or (2) ALTER {SYSTEM|SESSION}
QUERY_REWRITE_INTEGRITY = STALE_TOLERATED or (3) refresh the
materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-13913: The threshold cannot be set when SYSAUX is offline.
ORA-06562: type of out argument must match type of column or bind variable
ORA-08451: invalid specification of DB in picture mask
LSX-00027: property "~s" unknown
ORA-30456: 'string.string' cannot be refreshed because of insufficient privilege
TNS-00130: Failed to create Interchange's internal address
ORA-28174: Kerberos ticket not provided by proxy
RMAN-06168: no backup pieces with this tag found: string
ORA-09719: osncui: invalid handle.
ORA-29909: label for the ancillary operator is not a literal number
ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
ORA-39095: Dump file space has been exhausted: Unable to allocate string bytes
Oracle Errors 
