Here I am going to show the power of SQL Loader + Unix Script utility where multiple data files can be loaded by the SQL loader with automated shell scripts. This would be useful while dealing with large chunks of data and when data needs to be moved from one system to another system.

It would be suitable for a migration project where large historical data is involved. Then it is not possible to run the SQL loader for each file and wait till it’s loaded. So the best option is to keep the Unix program containing the SQL loader command running all the time. Once any file is available in the folder location then it will pick up the files from that folder location and start processing immediately.

Leave a Reply

Your email address will not be published. Required fields are marked *