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

DRG-11878: Loading New Rules Must Be Explicitly Acknowledged

1 Answers  


O2F-00324: Unable to convert from the database character set to the compiler character set

1 Answers  


ORA-12548: TNS:incomplete read or write

1 Answers  


ORA-30556: functional index is defined on the column to be modified

1 Answers  


ORA-31523: could not find change source string for CDC change set string

1 Answers  


ORA-16790: The value of the configurable property is invalid

1 Answers  


ORA-13148: failed to generate SQL filter

1 Answers  


SQL*Loader-00941: Error during describe of table string

1 Answers  


ORA-09827: SCLGT: atomic latch return unknown error.

1 Answers  


IMG-00844: internal image data allocation failed

1 Answers  


ORA-19813: cannot have unavailable file string in DB_RECOVERY_FILE_DEST

1 Answers  


ORA-16563: unable to add value, syntax error at "string"

1 Answers  


Categories