974675 wrote:YES, COMMIT inside LOOP is excellent way to generate ORA-01555 error
I am trying to use "Bulk Insert" for inserting 10 million records. This piece of code is placed in the procedure. To my bad, I could often find the procedure(run by a batch process) is getting error-ed out with the issue "Snapshot too old".
Going through few blogs made me feel that increase of the Undo retention size cold help.
My question is : Does the in between "COMMIT" contributes to the error. The value for the commit in between the Bulk Insert is 100,000.