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-07580: spstp: $GETJPIW failure

1 Answers  


NNL-00035: File string or nested IFILEs not found.

1 Answers  


IMG-00806: invalid input image

1 Answers  


ORA-23340: incorrect resolution method string

1 Answers  


ORA-39956: duplicate setting for PL/SQL compiler parameter string

1 Answers  






RMAN-08580: channel string: starting datafile copy

1 Answers  


ORA-09787: sllfop: unrecognizable processing option, incorrect format.

1 Answers  


ORA-12855: cannot run parallel or insert direct load in a loopback

1 Answers  


ORA-01934: circular role grant detected

1 Answers  


ORA-28038: disallow O2LOGON

1 Answers  


ORA-25278: grantee name cannot be NULL

1 Answers  


ORA-30180: argument index is too large

1 Answers  


Categories