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

NZE-28866: Invalid peer certificate encoding

1 Answers  


ORA-21301: not initialized in object mode

1 Answers  


ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.

1 Answers  


NNL-00524: Replaces a data item with another data item

1 Answers  


ORA-30511: invalid DDL operation in system triggers

1 Answers  






KUP-04039: unexpected error while trying to find file string in string

1 Answers  


RMAN-06049: CHECK LOGICAL option not supported for archive log or current/standby controlfile copies

1 Answers  


LFI-00152: Read operation (byte mode) failed.

1 Answers  


LRM-00109: could not open parameter file 'string'

1 Answers  


RMAN-06071: could not open datafile string

1 Answers  


ORA-25111: creation of BITMAP cluster indices is not supported

1 Answers  


ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


Categories