Re: Creating a Database Link to a Remote Database

From: PH_at_NToN <(PH_at_NToN)>
Date: Fri, 11 Feb 2000 14:39:16 GMT
Message-ID: <38a61cbc.16453238_at_news.supernews.com>


[Quoted] Verify listener of database

[Quoted] 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???????
>
Received on Fri Feb 11 2000 - 15:39:16 CET

Original text of this message