aiaiDBA

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

13718043309

010-86462881

QSM-02205: PCT FAST REFRESH is not possible if there is a subquery inside select-list

QSM-02205: PCT FAST REFRESH is not possible if there is a subquery inside select-list
Cause: The capability in question was not supported because the materialized view query contained a subquery inside a select-list.
Action: Rephrase the query to avoid the use of a subquery inside a select-list.

请先 登录 后评论

1 个回答

小智
QSM-02205:如果选择列表中有子查询,则不能进行快速刷新,
.原因:由于物化视图查询在选择列表中包含子查询,因此不支持该问题的能力。,
.操作:重新执行查询以避免在选择列表中使用子查询。,
.
请先 登录 后评论