Re: sqlloader script

Posted by ErmanArslansOracleBlog on Sep 05, 2017; 9:34am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/sqlloader-script-tp3394p3397.html

If I understand you correctly, you want sqlloader to load  multiple .dat files instead of a single concataneted one. If this is what you are looking for, leave that dat files as is and write a wrapper script to execute sqlloader in a loop by giving the .dat files  as arguments one by one it.
The script can list the files, take them into an array and executing sqlloader command for each one of them.
This can be achieved by a bash script.

I mean, this can be achieved with a single ctl file.. (If the data in dat files are going into the same table and if they all have the same format  you only need 1 control file. ), so above method is okay.

You can also easily load all the dat files in a directory using a one-liner like below;

here is a windows loop example:
C:\erman>for %f in ( *.dat ) do sqlldr system/manager data.ctl data=%f