need help with SQLLDR.exe

I am using SQLLDr to populate a table from a flat file. I have created the following files:
.CTL  which describes the columns and position to populate

MY SQL statement look like this:

SQLLDR.exe parfile=abc.par

What I dont understand is what the PAR file is supposed to be doing. Can anyone help me with this PAR file?
$ORACLE_HOME/bin/sqlldr.exe parfile=$cmddir/sap_inv.par
 
 
and this is my PAR file
 
USERID=abc/abc
CONTROL=I:/xx/dev/bin/sap_inv.ctl
BAD=I:/xx/sapTOlims/sap_inv.bad
LOG=I:/xx/sapTOlims/sap_inv.log
ERRORS=99999

Open in new window

joekeriAsked:
Who is Participating?
 
MilleniumaireConnect With a Mentor Commented:
PAR is short for PARAMETER.

The PAR file contains the PARAMETERS that SQL Loader will use to load the file.

Your PARAMETER file contains the USERID, CONTROL, BAD, LOG and ERRORS parameters.

If you didn't use a parameter file you would have to specify all these parameters on your sqlldr command line e.g.

SQLLDR.exe USERID=abc/abc CONTROL=I:/xx/dev/bin/sap_inv.ctl BAD=I:/xx/sapTOlims/sap_inv.bad LOG=I:/xx/sapTOlims/sap_inv.log ERRORS=99999

The parameter file is simply another way of invoking sqlldr where the parameters are stored in a file instead of specified on the command line.
0
 
joekeriAuthor Commented:
EXCELLENT!!! thank you for your time and help... Your reply was exactly what I was looking for....
0
All Courses

From novice to tech pro — start learning today.