aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-02073: non-primary key RepAPI mv is not fast refreshable

QSM-02073: non-primary key RepAPI mv is not fast refreshable
Cause: Fast refresh is supported for RepAPI materialized views only if it is also a primary key materialized view.
Action: Re-design the materialized view to be a primary key materialized view.

请先 登录 后评论

1 个回答

小智
QSM-02073:非主键RepAPI mv不能快速刷新,
.原因:只有当RepAPI实体化视图也是主键实体化视图时,才支持快速刷新。,
.操作:将物化视图重新设计为主键物化视图。,
.
请先 登录 后评论