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

ORA-27146: post/wait initialization failed

1 Answers  


RMAN-06040: controlfile is already restored to file string

1 Answers  


ORA-00214: controlfile 'string' version string inconsistent with file 'string' version string

1 Answers  


ORA-30176: invalid format code used in the format string

1 Answers  


ORA-27202: skgfpen: sbtpcend returned error

1 Answers  


ORA-16201: Skip procedure requested to apply statement

1 Answers  


ORA-06102: NETTCP: cannot allocate context area

1 Answers  


RMAN-10000: error parsing target database connect string "string"

1 Answers  


ORA-01537: cannot add data file 'string' - file already part of database

2 Answers  


ORA-13187: subdivision failed

1 Answers  


ORA-16779: The destination parameter of some database has wrong syntax.

1 Answers  


ORA-13832: category name specified is invalid

1 Answers  


Categories