Re: {URGENT} SQL Loader Help!!

Insted of
sqlldr80 userid_at_databasename control=mine.ctl log=mine.log try
sqlldr80 userid=userid_at_databasename control=mine.ctl log=mine.log

you can also create a parfile to hold your info and log on w/o entering a password and w/o the password displaying in v$session.

Example
sqlldr80 parfile=filename

filename contains:
userid=userid/password_at_databasename
control=mine.ctl
log=mine.log

In article <81gljl$ln6$1_at_nnrp1.deja.com>,   Billy Collins <billy_collins_at_my-deja.com> wrote:
> Hi,
>
> I would like to know how one uses the SQLLDR80 utility from the
command
> line. When I try to use it, I get the following error:
>
> ----
> ORA-12203: TNS: Unable to connect to destination
> SQL*Loader-704: Internal Error: ulconnect: OCIServerAttach[-1]
> ----
>
> What could be the problem here? Actually its a bit perplexing to
> me..how does one use SQLLDR80 to understand which Database you wish to
> connect to? Can I specifically specify it in the command line prompt
> (MSDOS)?
>
> I tried this:
>
> ----
> sqlldr80 userid_at_databasename control=mine.ctl log=mine.log
> ---
>
> and got this on the screen:
>
> ---
> User Password:
> ----
>
> After I entered the correct password, it gave me the error again!
>
> My userID and password work from the SQLPLUS and Net8 (TEST), and also
> from Visual basic and Powerbuilder..
>
> Why not from the command line?
>
> Please help!!!!
>
> Thanks very much in advance..
>
> Cheers
> Billy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Doug Coan
Senior Client Server System Integrator
AEGON USA
dcoan_at_aegonusa.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 11:45:44 CST