Re: SQL Loader

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/06
Message-ID: <960307986.13505.0.pluto.d4ee154e@news.demon.nl>#1/1

sqlload username/password_at_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_at_yahoo.co.uk> schreef in berichtnieuws 8hj36k$2dv$1_at_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.
Received on Tue Jun 06 2000 - 00:00:00 CDT