This discussion is archived
9 Replies Latest reply: Dec 3, 2012 11:51 AM by 977678 RSS

Bulk Insert for 10 million records - Error - Snap shot too old

977678 Newbie
Currently Being Moderated
Hi

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.

Thanks in advance !

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points