Its not running oout of rollback segment. The problem is that it take around 25 minutes per update statement and i need to do 50 similar updates thats a total of 20 Hrs approx.

I am sure that there must be a better and faster way to do a similar thing.

Thanks