QSM-01079: DML operation occurred on a table referenced by
MV, string
- 1 Answers
- 1490 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 |
SQL*Loader-00475: field for dynamic file name is string in table string
ORA-25288: AQ HTTP propagation encountered error, status-code number, string
QSM-01057: no query rewrite for this DML expression
RMAN-20205: incomplete UNTIL clause
ORA-01479: last character in the buffer is not Null
PCC-00068: Host and indicator variables may not have the same name.
ORA-21600: path expression too long
RMAN-04010: target database Password:
TNS-12227: TNS:syntax error
RMAN-20201: datafile not found in the recovery catalog
LFI-01514: ftell() failed in string
ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated
Oracle Errors 
