QSM-02169: the materialized view contains partition extended table name

QSM-02169: the materialized view contains partition extended table name
Cause: Fast refresh of materialized aggregate views and/or materialized join views are not supported if they were defined using partition extended table names.
Action: Create the fast refreshable materialized view without using partition extended table names or create the materialized view as a complete refresh materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02169：物化视图包含分区扩展表名,
.原因：如果使用分区扩展表名定义了物化化聚合视图和/或物化连接视图，则不支持快速刷新。,
.操作：创建快速可刷新的物化视图，而不使用分区扩展表名称，或者将物化视图创建为完整的刷新实例化视图。,
.

aiaiDBA

13718043309

010-86462881

QSM-02169: the materialized view contains partition extended table name

1 个回答

相似问题