Thursday, November 14, 2013

ORA-01591: lock held by in-doubt distributed transaction

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