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-29824: operator is invalid

1 Answers  


ORA-37122: AW Session cache disabled

1 Answers  


TNS-12606: TNS: Application timeout occurred

1 Answers  


ORA-30335: JOIN KEY clause references a level not in this hierarchy

1 Answers  


EXP-00102: Resumable parameters ignored -- current session not resumable

1 Answers  


PCC-02418: Array size mismatch between Object and REF host variables

1 Answers  


PLS-00630: pipelined functions must have a supported collection return type

2 Answers  


ORA-02140: invalid tablespace name

1 Answers  


ORA-39006: internal error

1 Answers  


ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

1 Answers  


ORA-09271: szlon: error verifying user name

1 Answers  


QSM-02083: mv references PL/SQL function that maintains state

1 Answers  


Categories