From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Subject: Re: SQL Loader
Date: 2000/06/06
Message-ID: <960307986.13505.0.pluto.d4ee154e@news.demon.nl>#1/1
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
References: <8hj36k$2dv$1@nnrp1.deja.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Complaints-To: abuse@nl.demon.net
X-Trace: news.demon.nl 960307986 pluto:13505 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-MSMail-Priority: Normal
Newsgroups: comp.databases.oracle.server


sqlload username/password@servicename

Servicename must have been defined in your tnsnames.ora and is pointing to
the other database.
Tnsnames.ora normally is in
%ORACLE_HOME%\network\admin in 7.3 and 8i
in %ORACLE_HOME%\net8\admin for 8.0

Hth,

Sybrand Bakker, Oracle DBA


<lwithington@yahoo.co.uk> schreef in berichtnieuws
8hj36k$2dv$1@nnrp1.deja.com...
> 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.