QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode

QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode
Cause: A materialized view with PL/SQL functions in its definition cannot be used for query rewrite when query rewrite integrity is set to ENFORCED.
Action: Consider running the query in STALE TOLERATED mode.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:54

QSM-01030：物化视图，字符串，在强制完整性模式下具有PL / SQL功能,
.原因：当查询重写完整性设置为ENFORCED时，其定义中具有PL / SQL功能的物化视图不能用于查询重写。,
.操作：请考虑以STALE TOLERATED模式运行查询。,
.

aiaiDBA

13718043309

010-86462881

QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode

1 个回答

相似问题