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-29510: name, string.string, already used by an existing object

1 Answers  


ORA-14639: SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition

1 Answers  


NNL-00872: Updates refused, data is topology data: number

1 Answers  


TNS-03503: Could not initialize NL

1 Answers  


PROT-00007: Failed to open the specified import file

1 Answers  


ORA-30108: invalid positional parameter value 'string'

1 Answers  


PLS-01714: ANSI expects a column name not a literal value here

1 Answers  


ORA-08441: closed parenthesis missing in picture mask

1 Answers  


ORA-06305: IPA: Illegal message type

1 Answers  


ORA-06141: NETTCP: no privilege for user

1 Answers  


LSX-00176: circular reference detected in schema component named "~S"

1 Answers  


ORA-12008: error in materialized view refresh path

1 Answers  


Categories