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-02267: column type incompatible with referenced column type

1 Answers  


SQL*Loader-00428: count for field string not stored in character or integer field

1 Answers  


ORA-31624: operation string not allowed when job in string state

1 Answers  


SQL*Loader-00134: invalid option specified for EXTERNAL_TABLE parameter

1 Answers  


SQL*Loader-00524: partial record found at end of datafile (string)

1 Answers  


ORA-16721: unable to set LOG_ARCHIVE_DEST_n parameters

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


PLS-01506: CREATE INDEX is non-ANSI

1 Answers  


RMAN-06030: the DELETE [ALL] INPUT option may not be used with a datafile backup set

1 Answers  


DRG-13000: error while adding or removing a sub lexer

1 Answers  


ORA-12484: invalid OS label

1 Answers  


PLS-00325: non-integral numeric literal string is inappropriate in this context

1 Answers  


Categories