ORA-26536: refresh was aborted because of conflicts caused by deferred transactions

ORA-26536: refresh was aborted because of conflicts caused by deferred transactions
Cause: There are outstanding conflicts logged in the DEFERROR table at the materialized view's master site.
Action: Resolve the conflicts in the master DEFERROR table and refresh again after the table is empty. Alternatively, refresh with REFRESH_AFTER_ERRORS, even if there are conflicts in the master's DEFERROR table. Proceeding despite conflicts can result in 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:46

ORA-26536：刷新由于延迟事务导致的冲突而中止,
.原因：在物化视图的主站点的DEFERROR表中记录了未完成的冲突。,
.操作：解决主DEFERROR表中的冲突，并在表为空之后再次刷新。或者，使用REFRESH_AFTER_ERRORS刷新，即使主设备的DEFERROR表中存在冲突。尽管冲突可以导致可更新的物化视图的更改似乎暂时丢失，直到刷新在冲突解决后成功。,
.

aiaiDBA

13718043309

010-86462881

ORA-26536: refresh was aborted because of conflicts caused by deferred transactions

1 个回答

相似问题