Andrew Fraser DBA

Remove dba_2pc_pending records

Old entries in dba_2pc_pending can be removed by ‘rollback force’ or if that fails, with a purge:

set pages 9999
spool go.tmp
select 'rollback force '''||local_tran_id||''' ;' from dba_2pc_pending ;
select 'exec dbms_transaction.purge_lost_db_entry('''||local_tran_id||''' )' , 'commit;' from dba_2pc_pending ;
spool off