Re: {URGENT} SQL Loader Help!!

sqlldr80 scott/tiger_at_ORCL

or what ever instance you want to connect to.

Billy Collins wrote in message <81gljl$ln6$1_at_nnrp1.deja.com>...
>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.
Received on Wed Nov 24 1999 - 08:51:33 CST