aiaiDBA

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

13718043309

010-86462881

ORA-32346: ON COMMIT materialized view refresh caused changes to the master table/materialized view

ORA-32346: ON COMMIT materialized view refresh caused changes to the master table/materialized view
Cause: ON COMMIT refresh of a read-only materialized view changed the master table/materialized view. A trigger on the refreshed materialized view may be the cause.
Action: Do not create triggers on materialized view which update the master table/materialized view.

请先 登录 后评论
默认排序 时间排序

1 个回答

小智
ORA-32346：ON COMMIT实体化视图刷新导致对主表/物化视图的更改,
.原因： ON COMMIT刷新只读实例化视图更改了主表/物化视图。刷新的物化视图上的触发器可能是原因。,
.操作：不要在更新主表/物化视图的物化视图上创建触发器。,
.
请先 登录 后评论
  • 1 关注
  • 0 收藏，624 浏览
  • 慧慧 提出于 2018-08-30 16:50

相似问题