ORA-23402: refresh was aborted because of conflicts caused by deferred txns

ORA-23402: refresh was aborted because of conflicts caused by deferred txns
Cause: There are outstanding conflicts logged in the DefError table at the materialized view's master.
Action: Resolve the conflicts in the master DefError table and refresh again after the table is empty. Alternatively, refresh with refresh_after_errors set to TRUE, which will proceed with the refresh even if there are conflicts in the master's DefError table. Proceeding despite conflicts can result with an updatable materialized view's changes appearing to be temporarily lost (until a refresh succeeds after the conflicts are resolved).

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-23402：刷新被中止，因为由延迟txns引起的冲突,
.原因：在物化视图的主节点的DefError表中记录了未完成的冲突。,
.操作：解决主DefError表中的冲突，并在表为空之后再次刷新。或者，refresh_after_errors设置为TRUE时刷新，即使主设备的DefError表中存在冲突，刷新也将继续刷新。继续进行，尽管冲突可能导致可更新的物化视图的更改似乎暂时丢失（直到刷新在冲突解决后成功）。,
.

aiaiDBA

13718043309

010-86462881

ORA-23402: refresh was aborted because of conflicts caused by deferred txns

1 个回答

相似问题