9 Replies Latest reply: Dec 3, 2012 1:51 PM by 977678 RSS

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


      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 !