ora-02049 while inserting data into a table

lab2>select name,value from v$parameter where name like '%distri%';

 

NAME                                                   VALUE

distributed_lock_timeout            60

lab2>alter system set distributed_lock_timeout=300 scope=spfile;

 

System altered.

lab2>SELECT local_tran_id,state,status FROM sys.pending_trans$;

 

LOCAL_TRAN STATE            S

---------- ---------------- -

3.33.11536 collecting       P

SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('3.33.11536');

BEGIN DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('3.33.11536'); 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

 

SQL> alter session set "_smu_debug_mode" = 4;

 

Session altered.

 

SQL> commit;

 

Commit complete.

 

SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('3.33.11536');

 

PL/SQL procedure successfully completed.

SQL> commit;

 

Commit complete.