Re: database link

From: <buckeye714_at_my-deja.com>
Date: Wed, 17 Jan 2001 20:33:16 GMT
Message-ID: <944vic$ha9$1@nnrp1.deja.com>

In article <944q45$brv$1_at_nnrp1.deja.com>, henry00_at_my-deja.com wrote:
> I create a data base link like:
>
> create database link remote_connect
> connect to user identified by mypassword
> using 'instance.mycompany.com';
>
> I had a table named test in the remote database
instance.mycompany.com.
> When I tried to use select query on test table, I got the error
message:
> ERROR:
> ORA-02085: database link REMOTE_CONNECT.MYCOMPANY.COM connects to
> INSTANCE.MYCOMPANY.COM
>
> What go wrong here?
>
> Thanks
>
> Sent via Deja.com
> http://www.deja.com/
>

Check to see if you have GLOBAL_NAMES = TRUE in your intitialization file. With GLOBALS NAMES = TRUE, the database link must have the same name as the database it links to. Two options are recreate the database link and call it INSTANCE.MYCOMPANY.COM, or set GLOBAL_NAMES = FALSE and bounce the instance. Please read the documentation for implications on setting GLOBAL_NAMES before you change it.

HTH,
Patrick

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 17 2001 - 14:33:16 CST