aiaiDBA

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

13718043309

010-86462881

ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs

ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs
Cause: A Partition Maintenance Operation (PMOP) has been performed on the materialized view, and no materialized view supports fast refersh after container table PMOPs.
Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

请先 登录 后评论

1 个回答

小智
“ string ”的REFRESH FAST 。“ string ”在容器表PMOP之后不受支持,
.原因:已在物化视图上执行分区维护操作(PMOP),并且没有物化视图支持容器表PMOP之后的快速引用。,
.操作:使用REFRESH COMPLETE。注意:您可以确定物化视图为什么不支持使用DBMS_MVIEW.EXPLAIN_MVIEW()API的PMOP后快速刷新。,
.
请先 登录 后评论