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-01079: DML operation occurred on a table referenced by
MV, string



QSM-01079: DML operation occurred on a table referenced by MV, string..

Answer / guest

Cause: If any dependent tables of a materialized view
undergoes a DML operation, query rewrite may be restricted
depending on the query rewrite integrity mode for the
session. In this situation, query rewrite will take place
only if the rewrite integrity mode is STALE_TOLERATED.

Action: Consider refreshing the materialized view chaning
the rewrite integrity mode to STALE_TOLERATED.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00307: too many declarations of 'string' match this call

1 Answers  


EXP-00021: can only perform incremental export in Full Database mode

1 Answers  


NMP-00007: I/O failure

1 Answers  


DRG-12009: A new set of rules is requested to be added to your setup - continue?

1 Answers  


TNS-12602: TNS: Connection Pooling limit reached

1 Answers  


ORA-19725: can not acquire plug-in enqueue

1 Answers  


ORA-27156: request for process information failed

1 Answers  


NNL-00352: Cancelled save config

1 Answers  


DRG-11712: multiple Broader Terms for term string

1 Answers  


NNL-00258: Server-generated requests currently do not require authoritative answers

1 Answers  


PLS-01451: The data types of these <value expressions> must be comparable

1 Answers  


ORA-03246: Invalid block number specified

1 Answers  


Categories