Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

SQL*Loader-00475: field for dynamic file name is string in table string

1 Answers  


ORA-25288: AQ HTTP propagation encountered error, status-code number, string

1 Answers  


QSM-01057: no query rewrite for this DML expression

1 Answers  


RMAN-20205: incomplete UNTIL clause

1 Answers  


ORA-01479: last character in the buffer is not Null

1 Answers  






PCC-00068: Host and indicator variables may not have the same name.

1 Answers  


ORA-21600: path expression too long

1 Answers  


RMAN-04010: target database Password:

1 Answers  


TNS-12227: TNS:syntax error

1 Answers  


RMAN-20201: datafile not found in the recovery catalog

1 Answers  


LFI-01514: ftell() failed in string

1 Answers  


ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated

1 Answers  






Categories