Re: linking to another server

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Wed, 20 Dec 2000 21:05:02 GMT
Message-ID: <91r6to$mcd$1@nnrp1.deja.com>

First, you have to have sqlnet connection to remote database. You should be able to run sqlplus connecting to remote DB. If you can, here's the next step:

On local DB, run

Create database link <link_name> connect to <username> identified by <password> using '<connect string>'

Attention: if you have init.ora parameter GLOBAL_NAMES = TRUE, link_name should be equal to remote database name. Better option is to have GLOBAL_NAMES = FALSE. In article <Vz806.101109$Z2.1198526_at_nnrp1.uunet.ca>, "Choung Chao" <cchao_at_pmc.ca> wrote:
> Hi,
>
> I'm pretty new to Oracle.
>
> I want to know how do I create a connection from my existing computer
to the
> server.
>
> I'm running windows2000. I have oracle 8.1.5 installed on my machine. I
> want to connect to another database on the server which is an NT
> workstation. I'm trying to connect in another oracle 8.1.5 databse. How
> would I do this?
>
> thanks
>
> Choung
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 15:05:02 CST