清除分布式事务，结果报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;