Re: Creating a Database Link to a Remote Database
Date: Thu, 3 Feb 2000 15:33:12 +1300
Message-ID: <yH5m4.23$8Te.327703_at_news.xtra.co.nz>
Make sure the Oracle parameter global_names is set to false on your remote machine.
Also the service name you use 'vishay.world' must exist in the tnsnames.ora of your local server.
Paul
Jamie Painter wrote in message <86sve2$4ki$1_at_nntp5.atl.mindspring.net>...
>I am having a problem creating connecting to a remote database. I can
create
>the database link with no problem. The statemenet that I used is below:
>
> SQL> create database link vishay.mcasey connect to vishays
>identified by vishays using 'vishay.world';
>
>However when I try to query the remote database I get the following error:
>
>ERROR at line 1:
>ORA-02085: database link VISHAY.MCASEY connects to ORACLE.WORLD
>
>Any Ideas???????
>
>
Received on Thu Feb 03 2000 - 03:33:12 CET