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-38461: XML Tag "string" already exists for the XMLType attribute "string"

1 Answers  


ORA-00031: session marked for kill

1 Answers  


ORA-08447: syntax error in USAGE clause in mask options

1 Answers  


ORA-13282: failure on initialization of coordinate transformation

1 Answers  


ORA-38766: cannot flashback data file string; file resized smaller

1 Answers  






KUP-04082: error converting field string for LOBFILE column string

1 Answers  


ORA-19210: column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'

1 Answers  


ORA-01583: unable to get block size of controlfile to be backed up

1 Answers  


LFI-01503: Max filename size exceeded generating filename.

1 Answers  


ORA-16643: unable to determine location of broker configuration files

1 Answers  


ORA-29524: wrong types of arguments in call to 'string'

1 Answers  


ORA-32641: invalid expression in MODEL rule ORDER BY clause

1 Answers  


Categories