Re: How can tables from two different databases be linked

From: Tim Hentzel <thentzel_at_yahoo.com>
Date: 2000/05/21
Message-ID: <8g9m4k$r09$1@nnrp1.deja.com>#1/1

here is the basic syntax for creating a link.

<obvious>the reference material will provide more descriptive info.</obvious>

CREATE DATABASE LINK <link name here -- how you will reference tables> CONNECT TO <schema you are connecting to> IDENTIFIED BY <schema password here>
USING '<the tns entry from the server>'

hth,
tim

In article <267801cd.5028622e_at_usw-ex0103-024.remarq.com>, ggraudins <ggraudinsNOggSPAM_at_exeter.com.invalid> wrote:
> Quite simple really - just use a database link. Then you can
> write stuff like
>
> SELECT a.name, b.salary FROM a person_at_first_database, b
> salary_at_second_database WHERE a.person_id = b.person_id, etc.,
> etc.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> The fastest and easiest way to search and participate in Usenet -
Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun May 21 2000 - 00:00:00 CDT