Friday, April 13, 2012

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

No comments: