Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: I've a problem with the DATABASE LINK
If the name of the link = SID it's OK
but if the name of the link is <> SID is KO!!!
WHY ?
"andrew_webby at hotmail" <spam_at_no.thanks.com> a écrit dans le message news:
986382360.16587.0.nnrp-12.c30bdde2_at_news.demon.co.uk...
> 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 - 07:11:25 CDT