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 - 6 of 6 Answers

Anu

  • 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

Mahesh

  • 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