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:
Post a Comment