thank you very much
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message news:
b0bmctclp38nhr2kkob7aku3d6f0g1a4p6_at_4ax.com...
> On Wed, 4 Apr 2001 11:14:58 +0200, "Pierre HIRTH" <p.hirth_at_sbm.mc>
> wrote:
>
> >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
> >
>
>
> This is a TFAQ (Too Frequently Asked Question)
> (and you could well have searched google, it would have resolved your
> problem)
> But anyway:
> you have your global_names init.ora parameter set to true, which
> requires is database link name to be identical to the global_name of
> the database.
> So either set the parameter to false (and bounce the database)
> or correct either the link name or the global database name.
> You can change the global database name by issuing
> alter database rename global_name to ... (string *without* quotes)
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
Received on Thu Apr 05 2001 - 02:50:47 CDT
