Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

ORA-12714: invalid national character set specified

1 Answers  


ORA-12069: invalid object for offline instantiation

1 Answers  


RMAN-06206: Crosschecked string objects

1 Answers  


ORA-29347: Tablespace name validation failed - failed to match tablespace 'string'

1 Answers  


ORA-19729: File string is not the initial version of the plugged in datafile

1 Answers  


ORA-30991: cannot use DOM to add special attribute to schema-based parent

1 Answers  


ORA-12490: DBHIGH cannot be lowered

1 Answers  


ORA-12420: required procedures and functions not in policy package "string"

1 Answers  


NZE-28809: Cannot delete information from the data source.

1 Answers  


TNS-12504: TNS:listener was not given the SID in CONNECT_DATA

1 Answers  


QSM-02163: cannot use object id columns from materialized view log

1 Answers  


ORA-03277: invalid SIZE specified

1 Answers  


Categories