Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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..

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

More Oracle Errors Interview Questions

NNL-00501: set|show log_stats_interval [<seconds>] [<server_list>] : set|show the server's statistic counter logging interval

1 Answers  


RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE

1 Answers  


RMAN-08536: channel string: autobackup found: string

1 Answers  


ORA-22920: row containing the LOB value is not locked

1 Answers  


ORA-12485: new effective label not within effective clearance

1 Answers  






ORA-03123: operation would block

1 Answers  


ORA-30195: reserved for future use

1 Answers  


ORA-32732: Parallel Oradebug session is aborted

1 Answers  


NNL-00527: Shows, sets, or cancels the time when the server next checkpoints its cache

1 Answers  


ORA-02355: error opening file: string

1 Answers  


ORA-07393: unable to delete text file

1 Answers  


ORA-15093: buffer only contains string bytes, I/O requested is string bytes

1 Answers  






Categories