QSM-01079: DML operation occurred on a table referenced by
MV, string
- 1 Answers
- 2941 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 |
ORA-30550: index depends on a package/function spec/body which is not valid
ORA-07616: $CHANGE_CLASS failed in retrieving the specified device label
SQL*Loader-00935: Error verifying required option for parallel load.
PCC-00100: Non integer label is not ANSI
SQL*Loader-00309: No SQL string allowed as part of string field specification
NNL-00995: Unmatched responses received: number
ORA-06138: NETTCP: error during connection handshake
QSM-01015: GROUP BY clause has non-columns
NNO-00318: overriding next statistic counter reset, resetting in number seconds
ORA-23533: object "string"."string" can not be cached
ORA-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
ORA-10654: Table is of type temporary or external
Oracle Errors 
