Rollback Of Single Transaction

SQL> select local_tran_id from dba_2pc_pending; 

LOCAL_TRAN_ID
----------------------
10.1.1306666
11.29.1398766
12.21.996344
17.27.1267023
26.30.1222781
3.4.1280743
31.13.928667
38.1.469932
40.33.554319
42.2.502494
52.8.263605

LOCAL_TRAN_ID
----------------------
56.19.234600
58.12.278189
66.9.233351
7.32.277783

15 rows selected.

SQL> Rollback Force '26.30.1222781';

Rollback complete.

SQL> select local_tran_id from dba_2pc_pending where local_tran_id='26.30.1222781';

LOCAL_TRAN_ID
----------------------
26.30.1222781

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

PL/SQL procedure successfully completed.

SQL> select local_tran_id from dba_2pc_pending where local_tran_id='26.30.1222781';

no rows selected

SQL> select name from v$database;

NAME
---------
AJITHDB