Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Bulk load to database

Advisor ,
Jun 13, 2018 Jun 13, 2018

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

322
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 13, 2018 Jun 13, 2018
LATEST

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.

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