aiaiDBA

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

13718043309

010-86462881

QSM-02203: PCT FAST REFRESH is not possible if query has set operand query blocks

QSM-02203: PCT FAST REFRESH is not possible if query has set operand query blocks
Cause: The capability in question was not supported because the materialized view query contained set operand query blocks.
Action: Rephrase the query to avoid the use of set operand query blocks.

请先 登录 后评论

1 个回答

小智
QSM-02203:如果查询设置了操作数查询块,则无法进行快速刷新,
.原因:由于物化视图查询包含设置的操作数查询块,所以不支持该功能。,
.操作:重新执行查询以避免使用设置的操作数查询块。,
.
请先 登录 后评论