Re: Creating a Database Link to a Remote Database

If you are using 8i ( 8.1.5) or so,
the database link name needs to be the same as the database name on the remote server, if GLOBAL is set to true...

phanthon_at_usa.net (PH_at_NToN) wrote:

>
>Verify listener of database
>
>
>On Fri, 28 Jan 2000 15:41:43 -0500, "Jamie Painter"
><jdpainter_at_mindspring.com> wrote:
>
>>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???????
>>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Feb 11 2000 - 19:14:48 CET