QSM-01079: DML operation occurred on a table referenced by MV, string

QSM-01079: DML operation occurred on a table referenced by MV, string
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01079：由MV，string引用的表发生DML操作,
.原因：如果物化视图的任何依赖表经历DML操作，则可能会根据会话的查询重写完整性模式限制查询重写。在这种情况下，仅当重写完整性模式为STALE_TOLERATED时才会进行查询重写。,
.操作：考虑将重写完整性模式的实例化视图刷新到STALE_TOLERATED。,
.

aiaiDBA

13718043309

010-86462881

QSM-01079: DML operation occurred on a table referenced by MV, string

1 个回答

相似问题