Re: I've a problem with the DATABASE LINK

It looks to me like you are trying to use the database link from the wrong database.

If you are in recettes database and create the link to testrct there, you should stay in that database and do
select * from brigade_at_testrct;

If you want to reach data in recettes from testrct, you should create a link this this:
connect sbm/sbm_at_testrct
create database link recettes connect to SBM identified by SBM USING 'recettes';

The reason it doesn't work when you are in testrct is that there is no database link defined there. Also, you might want to try making a public database link instead, but the above appears to be your problem.

"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 - 06:05:39 CDT