Bulk load to database

Question

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 · Answer

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

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.