QSM-01099: non-tolerated reference to stale portion of mv for table string

QSM-01099: non-tolerated reference to stale portion of mv
for table string

Question Posted / guest

1 Answers
2365 Views
I also Faced
E-Mail Answers

QSM-01099: non-tolerated reference to stale portion of mv for table string..

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

Post New Answer