有啊,错误如下: SQL> execute dbms_snapshot.refresh('RY_DATA'); BEGIN dbms_snapshot.refresh('RY_DATA'); END;* ERROR at line 1: ORA-02055: distributed update operation failed; rollback required ORA-06512: at "SYS.DBMS_SNAPSHOT", line 604 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 661 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 641 ORA-06512: at line 1建立快照时都可以建立起来,用手工刷新时出现以上的错误
试试,先执行一个rollback语句,在执行快照更新过程。
为什么要“先执行一个rollback语句”,我在快照更新之前没有做任何事务操作啊
ORA-02055 distributed update operation failed; rollback required Cause: A failure during a distributed update operation may not have rolled back all effects of the operation. Since some sites may be inconsistent with others, the transaction must roll back to a savepoint or roll back entirely. Action: Roll back to a savepoint or roll back the entire transaction and resubmit the rolled-back statements.
to maohaisheng(www.chinaspirit.net) : 我的快照是可更新的,用完全刷新也不行。 “更新冲突”是更新时与什么会冲突呢?
我怀疑是分布式数据库中的事务没有回滚, 用dba_2pc_pending查找是否有出现绑定的现象,但没有找到记录啊 用select local_tran_id, tran_comment from pending_trans$; 也没有我本意是:想通过dbms_transaction包来回滚分布式数据库的事务,再进行刷新
SQL> execute dbms_snapshot.refresh('RY_DATA');
BEGIN dbms_snapshot.refresh('RY_DATA'); END;*
ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 604
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 661
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 641
ORA-06512: at line 1建立快照时都可以建立起来,用手工刷新时出现以上的错误
Cause: A failure during a distributed update operation may not have rolled
back all effects of the operation. Since some sites may be inconsistent with
others, the transaction must roll back to a savepoint or roll back entirely.
Action: Roll back to a savepoint or roll back the entire transaction and resubmit
the rolled-back statements.
我的快照是可更新的,用完全刷新也不行。
“更新冲突”是更新时与什么会冲突呢?
用dba_2pc_pending查找是否有出现绑定的现象,但没有找到记录啊
用select local_tran_id, tran_comment from pending_trans$; 也没有我本意是:想通过dbms_transaction包来回滚分布式数据库的事务,再进行刷新