Re: Call Sqlldr from DOS Batch.
Date: Tue, 25 Mar 2008 05:49:33 -0700 (PDT)
Message-ID: <a73cfedb-44dc-4f31-8f92-01647590e947@u69g2000hse.googlegroups.com>
On Mar 25, 7:13 am, spamb..._at_milmac.com (Doug Miller) wrote:
> In article <1206436364.771..._at_proxy.dienste.wien.at>, Laurenz Albe <inv..._at_spam.to.invalid> 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_HOME%
D:\oracle\ora92\bin
echo %ORACLE_SID%
DBNAME
This mean that I don't have to set it.
This is the complete cmd:
sqlldr username/password_at_mydbname.world 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