Re: Call Sqlldr from DOS Batch.

From: PowerOne <>
Date: Tue, 25 Mar 2008 05:49:33 -0700 (PDT)
Message-ID: <>

On Mar 25, 7:13 am, (Doug Miller) wrote:
> In article <>, Laurenz Albe <> wrote:
> >Check that the environment variables are set currectly by using "set".
> 'set' with no parameters displays the values of *all* environment variables;
> this is potentially a fairly large set. The values of individual variables can
> be displayed with 'echo %varname%' e.g.
> echo %ORACLE_HOME%

The echo of these var. say:
 echo %ORACLE_SID%
This mean that I don't have to set it.
This is the complete cmd:

   sqlldr username/ control=D:\loader.txt log=mylog.log bad=mybad.bad errors=1000000 direct=true

The parfile is used to hide the user and password. Received on Tue Mar 25 2008 - 07:49:33 CDT

Original text of this message