QSM-02178: MV has a view with UNION ALL that is not fast refreshable

QSM-02178: MV has a view with UNION ALL that is not fast refreshable
Cause: The materialized view has a view whose definition involves a UNION ALL query that does not satisfy the requirements for fast refresh.
Action: Check that the defining query of the view being referenced in the materialized view satisfies conditions for fast refresh of a UNION ALL materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02178：MV具有不能快速刷新的UNION ALL的视图,
.原因：物化视图具有视图，其定义涉及不满足快速刷新要求的UNION ALL查询。,
.操作：检查在物化视图中引用的视图的定义查询是否满足快速刷新UNION ALL物化视图的条件。,
.

aiaiDBA

13718043309

010-86462881

QSM-02178: MV has a view with UNION ALL that is not fast refreshable

1 个回答

相似问题