QSM-01099: non-tolerated reference to stale portion of mv
for table string
- 1 Answers
- 2153 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-15070: maximum number of files string exceeded in diskgroup "string"
ORA-00207: controlfiles are not for the same database
NNL-00912: Alias loops detected: number
ORA-09943: Allocation of memory for password list component failed.
ORA-23423: job number string is not positive
ORA-31618: dump file size too small
ORA-38475: The attribute set and the associated ADT are out of sync.
ORA-35066: (QFGET03) Extension number number is missing for EIF file string.
ORA-16506: out of memory
ORA-16235: DDL skipped because import has occurred
ORA-24395: cannot reinitialize non-existent pool
TNS-12679: Native services disabled by other process but required
Oracle Errors 
