SQL> select * from sys.pending_trans$ where local_tran_id = ‘26.2.2712168’;
no rows selected
SQL> select * from sys.pending_sessions$ where local_tran_id = ‘26.2.2712168’;
no rows selected
SQL> select * from sys.pending_sub_sessions$ where local_tran_id = ‘26.2.2712168’;
no rows selected
SQL> select * from dba_2pc_neighbors;
no rows selected
SQL> select * from dba_2pc_pending;
no rows selected
SQL> commit force ‘26.2.2712168’;
commit force ‘26.2.2712168’
*
ERROR at line 1:
ORA-02058: no prepared transaction found with ID 26.2.2712168
SQL> rollback force ‘26.2.2712168’;
rollback force ‘26.2.2712168’
*
ERROR at line 1:
ORA-02058: no prepared transaction found with ID 26.2.2712168
SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(‘26.2.2712168’);
BEGIN DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(‘26.2.2712168’); END;
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
ORA-06512: at “SYS.DBMS_TRANSACTION”, line 65
ORA-06512: at “SYS.DBMS_TRANSACTION”, line 85
ORA-06512: at line 1
SELECT KTUXEUSN, KTUXESLT, KTUXESQN, /* Transaction ID */
KTUXESTA Status,
KTUXECFL Flags
FROM x$ktuxe
WHERE ktuxeusn= 26;
no rows selected