ORA-32322: PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs

ORA-32322: PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
Cause: A table join dependent on another table on which PCT refresh is enabled has changed
Action: Use REFRESH FORCE which will pick the best possible refresh method on the materialized view

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-32322：PCT刷新的“ 字符串 ”。“ 字符串 ”不允许DMLs / PMOPs的序列,
.原因：依赖于启用PCT刷新的另一个表的表连接已更改,
.操作：使用REFRESH FORCE，它将在物化视图上选择最佳的刷新方法,
.

aiaiDBA

13718043309

010-86462881

ORA-32322: PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs

1 个回答

相似问题