Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01099: non-tolerated reference to stale portion of mv
for table string
- 1 Answers
- 3006 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-16046: Archive log destination failed due to failed dependent destination
SQL*Loader-00432: converted data too large
NNL-00813: Average query processing time: string
DRG-12226: a field section named string already exists in this section group
ORA-06960: Failed to access log file
ORA-13333: invalid LRS measure
ORA-27001: unsupported device type
NID-00141: No database name specified, previous attempt used string
NNL-00906: NOT A LEAF NAME responses sent: number
LPX-00264: send failed to host ~s
ORA-14150: missing SUBPARTITION keyword
ORA-38433: index "string" could not be maintained due to "string"
Oracle Errors 
