QSM-01279: query rewrite not possible because DML operation occurred on a table referenced by materialized view string

QSM-01279: query rewrite not possible because DML operation occurred on a table referenced by materialized view 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 changing the rewrite integrity mode to STALE_TOLERATED.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

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

aiaiDBA

13718043309

010-86462881

QSM-01279: query rewrite not possible because DML operation occurred on a table referenced by materialized view string

1 个回答

相似问题