Skip to main content
Inspiring
June 13, 2018
Question

Bulk load to database

  • June 13, 2018
  • 1 reply
  • 353 views

Hi All,

I am trying to bulk insert 102K records to oracle db. I found this:

Data Insert Issue from Coldfusion to Oracle - Stack Overflow

But it takes a lot of time.

Is there a way to do faster bulk inserts?

Thanks in advanced.

John

    This topic has been closed for replies.

    1 reply

    WolfShade
    Legend
    June 13, 2018

    Insert All is the way I normally do it, and if I have a lot of data I remember to extend the timeout, just in case.

    Another user in that SO post suggested Oracle Bulk Loader.  Do you have access to the *nix CLI?

    If not, INSERT ALL is your best bet.

    V/r,

    ^ _ ^

    UPDATE:  You'll probably need to read THIS before attempting the Oracle Bulk Loader.