From: Rick Collins <b_aggy@hotmail.com>
Subject: Re: SQL Loader
Date: 2000/06/06
Message-ID: <8hj67t$4rn$1@nnrp1.deja.com>#1/1
References: <8hj36k$2dv$1@nnrp1.deja.com>
X-Http-Proxy: 1.1 x73.deja.com:80 (Squid/1.1.22) for client 195.99.138.2
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Tue Jun 06 15:44:03 2000 GMT
X-MyDeja-Info: XMYDJUIDrixsite
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 95)


In article <8hj36k$2dv$1@nnrp1.deja.com>,
  lwithington@yahoo.co.uk wrote:
> I have a problem with SQL Loader.  I have Oracle server installed on
 my
> PC and I'm trying to run sql loader from the command line.  The
 problem
> is that the database I'm trying to load data into is on another
> physical machine on the network.  How do I specify that I want to load
> data to this machine's database and not the default one on my PC?
>
> Thanks for your help!
>
> Lucy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

I guess you need to make sure your pc is runnning SQLNet/Net8 and that
the remote server is configured in your local tnsnames.ora file.
The configured server name put into tnsnames.ora is then used with the
sqlldr command line i.e.  sqlldr sys/password@otherserver

The remote server will obviously need a listener process running to
receive the connection request.

Hope this helps. I'm pretty new to Oracle but I think this is right.

--
Rick Collins
Newbie DBA - Forever Learning.


Sent via Deja.com http://www.deja.com/
Before you buy.