Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01079: DML operation occurred on a table referenced by
MV, string
- 1 Answers
- 2740 Views
- I also Faced
- E-Mail Answers
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 |
O2I-00119: Warning reported by subsystem:
ORA-16128: User initiated shut down successfully completed
NNL-00899: OK responses sent: number
ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
ORA-06031: NETDNT: connect failed, unrecognized object name
NID-00140: Specified database name string does not match previous name used string
ORA-29702: error occurred in Cluster Group Service operation
TNS-12528: TNS:listener: all appropriate instances are blocking new connections
SQL*Loader-00929: Error parsing insert statement for table string.
ORA-31606: XML context number does not match any previously allocated context
RMAN-06001: error parsing job step library
ORA-14005: missing RANGE keyword
Oracle Errors 
