QSM-01079: DML operation occurred on a table referenced by
MV, string
- 1 Answers
- 2429 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 |
NNL-00296: Controller's local trace level changed from number to number
CLSS-02204: voting device not configured. [string] [string]
ORA-22808: REF dereferencing not allowed
DRG-50949: too many SQEs
TNS-01081: Started with pid=string
LSX-00215: value "~1S" whose total digits exceeds ~2d
NNL-00243: Processing of modification requests is now enabled
NNL-00544: Displays operations statistics
ORA-01571: redo version string incompatible with ORACLE version string
RMAN-06427: recovery catalog already exists
PLS-00257: illegal use of EXTERNAL clause in a TYPE or PACKAGE specification
ORA-04030: out of process memory when trying to allocate string bytes (string,string)
Oracle Errors 
