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
- 3128 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-00114: missing value for system parameter SERVICE_NAMES
ORA-24308: illegal define position
QSM-01007: query has NOREWRITE hint
ORA-28280: Multiple entries for ORACLE database password exist.
ORA-02464: Cluster definition can not be both HASH and INDEX
ORA-32012: failure in processing system parameters from restored SPFILE
ORA-28156: Proxy user 'string' not authorized to set role 'string' for client 'string'
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-01232: cannot start online backup - file string is being made read-only
ORA-22341: cannot assign supertype instance to subtype
NNO-00310: server restart countdown aborted
LSX-00164: no content specified in "~S"
Oracle Errors 
