Re: Creating a Database Link to a Remote Database

The error ORA-02085 is:
oerr ora 2085
02085, 00000, "database link %s connects to %s" // *Cause: a database link connected to a database with a different name.

//  The connection is rejected.
// *Action: create a database link with the same name as the database it
//  connects to, or set global_names=false.
//

HTH
   James

In article <38a61cbc.16453238_at_news.supernews.com>,   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???????
> >
>
>

--
Life is complex; it has real and imaginary parts.


Sent via Deja.com http://www.deja.com/
Before you buy.