SQL Loader : Generate new log file each time-CodePudding

I am using SQL Loader to import data from CSV file to a database table, and it works fine. Each time I run the command sqlldr, the log file is overridden with new infos. Is there a way to add a timestamp or something to keep the archive of those log files instead of overriding the same file and without passing the value in the command params.

.par file :

CONTROL=D:\projects\ctl\control.ctl
LOG=D:\projects\log\TRACK_MIGRATION.log
DATA=D:\projects\data\CUSTOMERS_SITES.csv

Want something like : TRACK_MIGRATION_20221229_113917.log

CodePudding user response：

You must modify the startup script to remove the log parameter from the parameter file and add the log parameter to the command line.

.par file

CONTROL=D:\projects\ctl\control.ctl
DATA=D:\projects\data\CUSTOMERS_SITES.csv

command line

sqlldr user/password@DB parfile=parfile.par log=log_