Highlighted

Bulk load to database

Advisor ,
Jun 13, 2018

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

Views

138

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Bulk load to database

Advisor ,
Jun 13, 2018

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

Views

139

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 13, 2018 0
LEGEND ,
Jun 13, 2018

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 13, 2018 0