Through pl sql i am updateing a table for balance from
main transaction table of 28 lac rows. AFTER EVERY UPDATE & INSERT I AM USING COMMIT.
i have 6 rollback segment online with 5 mb init, 5 mb next, 5 min extend
and auto extend option online. after updateing around 5 lac rows it gives
error that ORA-01555 SNAP**** TOO OLD

HOW CAN I SOLVE THE PROBLEM ????

THANKS IN ADVANCE

FROM ANUJ PATHAK
HERO PUCH
INDIA