Edi Yanto (何 萬 新)

If you have rows on the view DBA_2PC_PENDING, do the below actions (Just enter the TRANSACTION ID, got from the ORA-1591 error): Connect as SYS or SYSDBA DELETE FROM pending_trans$ WHERE local_tran_id = ‘&TRANSACTION_ID’; DELETE FROM pending_sessions$ WHERE local_tran_id = ‘&TRANSACTION_ID’; If you don’t have rows on the view DBA_2PC_PENDING, do the below actions (insert [...]