I read all the 11 posts about this problem
Code: Select all
ORA-01555: snapshot too old: rollback segment number 4 with name "RBS03" too small
Both reading from the same table
one job just reading from the table and writing in a sequential file
Array Size = 5000
Second reads form the table, does a look up againt a Hash file and updates the same table
Input-- Array Size 5000
Output -- Array Size 3000, Transaction Size 3000, and rows per transaction 3000
These two jobs ran successfully for the whole 29M records before ( Job1 processed 29 million rows; Job 2 processed 4M rows)
Today I am getting this error
All the posts discuss a lot about this problem
There is no clear cut solution
This is what I understan
1. Increase the roll back segment
2. Avoid doing jobs like this
3. Something about using before SQL and after SQL to set the rollback segment size i guess
4. Write to a sequential file and update the table
Can someone tell me if there is some other way or how they did it when they came across this situtaion?
If this error occured while the select and update took place simultaneoulsy, then it makes sense to me. But the update job finished 3 hrs before this error Aborted the other job where i just read the data from the table
Help me with this
Thanks
Kishan[/code]