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
- 3032 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 |
DRG-11529: token exceeds maximum length
DRG-50607: failed to obtain column info for cid string
ORA-31662: metadata transform name can not be defaulted
ORA-12436: no policy options specified
ORA-32603: invalid FREEPOOLS LOB storage option value
ORA-28530: Heterogeneous Services initialization error in NLS language ID
PCC-02203: found end of file when not expected
TNS-12601: TNS:information flags check failed
ORA-01161: database name string in file header does not match given name of string
IMG-00546: invalid page number specified
NZE-28776: Output buffer supplied is too small.
ORA-30656: column type not supported on external organized table
Oracle Errors 
