Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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.