ora-02062

admin

SQL> select local_tran_id,state from dba_2pc_pending;

LOCAL_TRAN_ID          STATE
---------------------- ----------------
52.15.105177410        collecting

SQL> execute dbms_transaction.purge_lost_db_entry('52.15.105177410');

PL/SQL procedure successfully completed.