sqlldr question: specifying location of log and bad files

[bi]

I am fairly new to sqlldr. I have inherited several control scripts that load data into various tables (one table per control script). We use a .par file to specify the parameters such as user/password, silent parms, and direct parms. The .par file is used for all control files.

The control and parameter files are in one directory, the data is in another, and the sqlldr command is run from yet another directory. The command is sqlldr parfile=parfile.par control=control1.ctl data=/dataload/data1.dat

The .log files are put in the directory from which the sqlldr command is run. The .bad files are put in the same directory as the .ctl files.

Is there any way in the control file to specify the location of the .log and .bad files? Or can you only do it on the command line?

 

[did02]

Hi Bi,

In your par file (or at the end of your command line) add these 2 parameters :
LOG=/home/.../log/xxx.log
BAD=/home/.../bad/xxx.bad

Hope it helps.
Did02

 

[Advocate]

have some free learning ... see sample chapter ...

http://www.oreilly.com/catalog/orsqlloader/

Best of Irish Luck, David.
djwilkes@hotmail.com