重庆思庄Oracle、Redhat认证学习论坛

标题: 删除DBA_2PC_PENDING中未提交分布式事务 [打印本页]

作者: 郑全 时间: 2021-8-30 17:24
标题: 删除DBA_2PC_PENDING中未提交分布式事务
SELECT 'EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(''' || LOCAL_TRAN_ID || ''');' || chr(9) || chr(10) || ' commit;'
from DBA_2PC_PENDING;

EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('213.20.74362');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('216.10.74405');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('216.13.108851');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('217.5.52040');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('219.0.53744');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('219.21.73086');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('219.27.82605');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('224.4.96649');
commit;
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('224.8.91311');
commit;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)