Bulk load to database

[jfb00]

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

[WolfShade]

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.