-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|