aiaiDBA

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

13718043309

010-86462881

QSM-02199: PCT FAST REFRESH is not possible if WHERE clause includes a subquery

QSM-02199: PCT FAST REFRESH is not possible if WHERE clause includes a subquery
Cause: The capability in question was not supported because the materialized view query WHERE clause included a subquery.
Action: Rephrase the query to avoid the use of a subquery in the WHERE clause.

请先 登录 后评论

1 个回答

小智
QSM-02199:如果WHERE子句包含子查询,则不能进行PCT快速刷新,
.原因:由于物理视图查询WHERE子句包含子查询,所以不支持该功能。,
.操作:重新执行查询以避免在WHERE子句中使用子查询。,
.
请先 登录 后评论