QSM-02154: MV is not fast refreshable even with view merging

QSM-02154: MV is not fast refreshable even with view merging
Cause: You have a materialized view with view in the FROM clause, however it does not meet the criteria for fast refresh after view merging.
Action: Restructure the materialized view query to remove the offending view or the complex construct in the view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02154：即使视图合并，MV也不能快速刷新,
.原因：您在FROM子句中具有视图的实例化视图，但不符合视图合并后快速刷新的条件。,
.操作：重构物化视图查询以删除视图中的违规视图或复杂构造。,
.

aiaiDBA

13718043309

010-86462881

QSM-02154: MV is not fast refreshable even with view merging

1 个回答

相似问题