Re: Newbies - How can I reference to a table using a synonyms via dblink to a remote server ?

Andy Hardy wrote:

> In article <7kfc65$ctl$1_at_birch.prod.itd.earthlink.net>, Kenny Lim
> <kennylim_at_earthlink.net> writes
> >Hi Guys,
> >
> >I am experimenting in how to query a table using a synonyms via dblink
> >referencing to a remote server.
> >
> >I received the following error messages :
> >
> >ORA-02085: database link name connects to name
> >
>
> Oracle documentation says:
>
> ORA-02085 database link name connects to name
>
> Cause:
> The database link attempted to connect to a database with a different
> name. The name of the database link must be the same name as the name of
> the database.
>
> Action:
> Create a database link with the same name as the database to which it
> connects.

Or change the value of the parameter 'global_names' from 'TRUE' to 'FALSE'.

GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects. If the value of GLOBAL_NAMES is FALSE, then no check is performed. Oracle recommends setting this parameter to TRUE to ensure the use of consistent naming conventions for databases and links.

If you use distributed processing, set GLOBAL_NAMES to TRUE to ensure a unique identifying name for your database in a networked environment.

Hope this help.
Ciao Received on Mon Jun 21 1999 - 03:44:37 CDT