Re: connectstring in a select-clause

Please connect to one database (in example wg73) and make database link eg. name test.
create database link test connect to "user" identified by "password" using jade7.world;
You must have the same tnsnames entries as you wrote on sever. Then you can select data from second database in form

select * from ais.alk_at_test;

Regards

Rafal Czekala (czekala_at_real.pl)

In article <7njklp$rr6$1_at_infosun2.rus.uni-stuttgart.de>,   "Roland Kopetzky" <kopetzky_at_ike.uni-stuttgart.de> 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_at_wg73.world
> or
> select * from ais.alk_at_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_at_arkusa.de)
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 29 1999 - 09:11:34 CDT