Re: Call Sqlldr from DOS Batch.

On Mar 25, 7:49 am, PowerOne <salazar.wi..._at_gmail.com> wrote:
> 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/passw..._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.

What does the following command report:

tnsping mydbname.world

It may be that your tnsnames.ora file is misconfigured or missing.

David Fitzjarrell Received on Tue Mar 25 2008 - 08:32:57 CDT