Bulk load to database

Hi All,

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

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.

Legend

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.

Sign up