Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: New to SQLLOADER

Re: New to SQLLOADER

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 22 Jun 1999 07:53:31 +0200
Message-ID: <7kn8fq$o74$1@news3.saix.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US