Xref: alice comp.databases.oracle.server:59147
Message-ID: <379DD278.3B1B@ibm.net>
Date: Tue, 27 Jul 1999 11:38:32 -0400
From: "Bruce L. Shultes" <shultes@ibm.net>
X-Mailer: Mozilla 2.02 (OS/2; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
To: Roland Kopetzky <kopetzky@ike.uni-stuttgart.de>
Subject: Re: connectstring in a select-clause
References: <7njklp$rr6$1@infosun2.rus.uni-stuttgart.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: 27 Jul 1999 15:41:13 GMT, 32.101.8.76
Organization: Global Network Services - Remote Access Mail & News Services
Lines: 82
X-Notice: Items posted that violate the IBM.NET Acceptable Use Policy
X-Notice: should be reported to postmaster@ibm.net
X-Complaints-To: postmaster@ibm.net
Path: alice!news-feed.fnsi.net!enews.sgi.com!logbridge.uoregon.edu!newsfeed.us.ibm.net!ibm.net!news1.us.ibm.net!32.101.8.76

Roland Kopetzky wrote:
> 
> Hey Experts,
> 
> I have two Oracle databases running on two different platforms. On a unix
> platform there is running Oracle 7.3.3 and on a NT-platform there is running
> an Oracle 8.0.3.
> 
> The statements select * form global_name retrieve:
> WG73.world   on the Unix-platform
> ARKU.world   on the NT platform
> 
> The TNSNAMES.ORA-contents on both platforms is:
> 
> rubin8.world =
>   (DESCRIPTION =
>     (ADDRESS_LIST =
>         (ADDRESS =
>           (COMMUNITY = tcp.world)
>           (PROTOCOL = TCP)
>           (Host = 95.95.95.2)
>           (Port = 1521)
>         )
>         (ADDRESS =
>           (COMMUNITY = tcp.world)
>           (PROTOCOL = TCP)
>           (Host = 95.95.95.2)
>           (Port = 1526)
>         )
>     )
>     (CONNECT_DATA = (SID = ARKU)
>     )
>   )
> jade7.world =
>   (DESCRIPTION =
>     (ADDRESS_LIST =
>         (ADDRESS =
>           (COMMUNITY = tcp.world)
>           (PROTOCOL = TCP)
>           (Host = jade)
>           (Port = 1521)
>         )
>         (ADDRESS =
>           (COMMUNITY = tcp.world)
>           (PROTOCOL = TCP)
>           (Host = jade)
>           (Port = 1526)
>         )
>     )
>     (CONNECT_DATA = (SID = WG73)
>     )
>   )
> 
> What I want to know is how to select data form one database when I am
> connected to the other. I would prefer to be connected to the NT-Oracle and
> to select data from the Unix-Oracle, but I think, it would be possible to do
> it vice versa as well.
> 
> When I am connected to NT-Oracle and I try:
> 
> select * from ais.alk@wg73.world
> or
> select * from ais.alk@jade7.world
>                       *
> I always get the error
> ORA-02019: connection description for remote database not found
> 
> Is this a distributed database problem? Should I set distributed option and
> if so, how can I do this?
> 
> Has anyone an idea what I have to configure or how I need to write the
> sql-statement to succeed?
> 
> Thanks for every advice.
> 
> Yours sincerely
> 
> Manfred Tischendorf (tischendorf@arkusa.de)
Manfred,

You need to CREATE DATABASE LINK linkname USING 'TNS:WG73'. Then you
should be able to successfully select * from ais.alk@linkname.