Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I create a link to a table in a remote database?

Re: Can I create a link to a table in a remote database?

From: janet <janet_at_telesph.com>
Date: 1997/02/20
Message-ID: <330C8B6F.3A3B@telesph.com>#1/1

> janet <janet_at_telesph.com> wrote:
> >i know you're on unix, so type
> >uname -n
> >on the remote database to give you the db name.
> >Ex: remote_database
> >
> >go to local database and
> >create public database link LINK_NAME
> >connect to USER identified by PWD
> >using 'remote_database';

Gary Assa wrote:
> Not many people out there will know what remote_database means.
> If you are using a TCP/IP system, remote_database is: T:{machine_name}:{SID}

in my example, "remote_database" was the example result of the command "uname -n"

if you wanted to pick on me because uname -n gives you the machine name and not the remote database, fine. but if you don't like the sample name i created...

janet Received on Thu Feb 20 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US