Re: Using database links to connect to a local database

Helllo Dick,

It seems the GLOBAL_NAMES parameter in your init.ora is set to TRUE, and that imply the database link must have the same name as the database name. So set the parameter to FALSE or re-create a database link with the same name as your database name (as TREND)

Regards. Olivier

Dick Willis wrote:

> Whenever I reference the local database in my SQL string, I receive the
> error:
> ORA-2085 database link TREND02.World connects to TREND.WORLD.
>
> I have defined the link TREND02 to be the local database. What is TREND?
> (local instance is called TRND (not TREND), but INTERNAL does have the
> password TREND, can't think of other places where TREND is used) and, more
> importantly, how do I construct a database link to the local database so
> that my general-purpose query can be used?
>
> --
> Dick Willis, Senior Engineer
> Synchrony Industrial Controls, Inc.
> rmw_at_synchrony.com
> http://www.synchrony.com
>
> --
> Dick Willis, Senior Engineer
> Synchrony Industrial Controls, Inc.
> rmw_at_synchrony.com
> http://www.synchrony.com
Received on Sun Mar 15 1998 - 00:00:00 CST