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

标题: 清除分布式事务，结果报ORA-01453 [打印本页]

---

作者: 郑全    时间: 2021-6-29 18:08
标题: 清除分布式事务，结果报ORA-01453
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('11.22.439075');
BEGIN DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('11.22.439075'); END;

*
ERROR at line 1:
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "SYS.DBMS_TRANSACTION", line 65
ORA-06512: at "SYS.DBMS_TRANSACTION", line 87
ORA-06512: at line 1



解决办法：

alter system set "_smu_debug_mode" = 4;
commit;
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('<local_tran_id>');
commit;

-- Once the transaction has been clean out, to reset the value of _smu_debug_modeto its default, use:

alter system set "_smu_debug_mode" = 0;
commit;

---

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

Powered by Discuz! X3.2