Re: I've a problem with the DATABASE LINK

I've found the following in the Oracle doc:

ORA-02085 database link string connects to string 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.

The following initialization parameter plays a role too :

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. If you use or plan to use distributed processing, Oracle Corporation
recommends that you set this parameter to TRUE to ensure the use of consistent naming
conventions for databases and links in a networked environment.

Hope i helped,

Achille Carette

"Pierre HIRTH" <p.hirth_at_sbm.mc> wrote in message news:9aeonf$2nc$1_at_news2.isdnet.net...
> Hi,
>
> I have two oracle databases (recettes and testrct) and a user SBM for each
> database
>
> SQL> connect sbm/sbm_at_recettes
> Connecté.
> SQL> create database link testrct
> 2 connect to SBM identified by SBM
> 3 USING 'testrct'
> 4 ;
>
> Database link created.
>
>
> SQL> connect sbm/sbm_at_testrct
> Connecté.
>
> SQL> select * from brigade_at_testrct;
> select * from brigade_at_testrct
> *
> ERREUR à la ligne 1 :
> ORA-02085: lien de base de données TESTRCT se connecte à RCT
>
> Some one could help me
>
> Thank's
>
>
Received on Wed Apr 04 2001 - 05:12:25 CDT