ORA-01591: lock held by in-doubt distributed transaction
SQL> select local_tran_id from dba_2pc_pending;
LOCAL_TRAN_ID
------------------------------------------------------------------
7.55.64129
SQL> rollback force '7.55.64129';
Rollback complete.
SQL> exec dbms_transaction.purge_lost_db_entry('7.55.64129');
PL/SQL procedure successfully completed.
SQL> select local_tran_id from dba_2pc_pending;
no rows selected
Enjoy :)
No comments:
Post a Comment