Load a file in oracle in chunks of 100 mb files

I need to load a single load ready file in oracle table in chunks of 100 mb files. How to do that?

Showing Answers 1 - 4 of 4 Answers


  • Jan 9th, 2020

What I would suggest is
1. Divide the file into 100 mb small files by using
Split -b Unix command
2. Then load the data into the table file by file

  Was this answer useful?  Yes


  • May 26th, 2021

The intention here seems for a failure after 100 records, so besides breaking the file into 100 recs each, you can set the commit param to 100

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions