Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: New to SQLLOADER
patrick_stdennis_at_my-deja.com wrote in message
<7km4av$jhp$1_at_nnrp1.deja.com>...
>Hello all,
>
>In all the documentation for SQLLOADER I haven't seen any place to put
>down the name of the oracle server you want to load to. Is this because
>you have to perform this on the server itself? Or is there something I
>am missing? I'm using Oracle8.0.3 for Winnt 4.
>
The server it connects to depends on the what is specified in the USERID parameter:
C:\> SQLLDR80 USERID=scott/tiger
-> SQL*Loader uses the ORACLE_SID environmental variable to determine the DB System ID of the local database to connect to.
C:\> SQLLDR80 USERID=scott/tiger_at_myserver
-> SQL*Loader uses the "myserver" alias in the file TNSNAMES.ORA in the %ORACLE_HOME%\network\admin (or %ORACLE_HOME%\net80\admin) directory.
regards,
Billy
Received on Tue Jun 22 1999 - 00:53:31 CDT