QSM-01029: materialized view, string, is stale in ENFORCED integrity mode

QSM-01029: materialized view, string, is stale in ENFORCED integrity mode
Cause: A stale materialized view cannot be used for query rewrite when the query rewrite integrity mode is set to ENFORCED.
Action: Refresh the materialized view or alter the rewrite integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY = STALE TOLERATED command.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:54

QSM-01029：物化视图，字符串，在强制完整性模式下陈旧,
.原因：当查询重写完整性模式设置为ENFORCED时，过期的实例化视图不能用于查询重写。,
.操作：使用ALTER SESSION QUERY_REWRITE_INTEGRITY = STALE TOLERATED命令刷新实例化视图或更改重写完整性模式。,
.

aiaiDBA

13718043309

010-86462881

QSM-01029: materialized view, string, is stale in ENFORCED integrity mode

1 个回答

相似问题