Rollback segment problem

[simply_dba]

Originally posted by davey23uk
well you are fetching across a commit - that is a such a bad thing to do and can guarantee yourself a ORA-1555 which you have got

I ran the delete without the commit also :

Delete from temp_tab a where exists
(select 1 from temp_tab b where ((a.amount>0
and b.AMOUNT<0) or(a.amount<0 and b.AMOUNT>0))
and abs(a.amount)=abs(b.AMOUNT)
and a.md=b.MD
and a.comment=b.COMMENT
and a.type=b.TYPE);

Got the same error
Latest update is :
Set undo retention to 5000
commit every 5000 rows instead of 1000
Any solutions??
Am really in a fix with this