Re: sqlplus to different server
From: Anette Hansen <Info_at_AHa-EDV.de>
Date: Tue, 17 Jul 2001 10:55:09 +0200
Message-ID: <9j0uhd$21a$1_at_ds10701a.msro.detemobil.de>
Date: Tue, 17 Jul 2001 10:55:09 +0200
Message-ID: <9j0uhd$21a$1_at_ds10701a.msro.detemobil.de>
<kossack80021_at_yahoo.com> wrote:
> I have 2 systems with oracle 8i
>
> using the command line, how would I enter sqlplus on one machine and query
a
> table on the other?
>
>
Hello,
1. start sqlplus (look at your OS)
2. create database link <databas_1> connect to <user> identified by <pwd> using <database_2>
3. Select * from dual_at_<database_2>
Regards, Anette Received on Tue Jul 17 2001 - 10:55:09 CEST