From: "andrew_webby at hotmail" <spam@no.thanks.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: I've a problem with the DATABASE LINK
Date: Wed, 4 Apr 2001 12:05:39 +0100
Message-ID: <986382360.16587.0.nnrp-12.c30bdde2@news.demon.co.uk>
References: <9aeonf$2nc$1@news2.isdnet.net>
NNTP-Posting-Host: mailgate.highland.gov.uk
X-NNTP-Posting-Host: mailgate.highland.gov.uk:195.11.221.226
X-Trace: news.demon.co.uk 986382360 nnrp-12:16587 NO-IDENT mailgate.highland.gov.uk:195.11.221.226
X-Complaints-To: abuse@demon.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Lines: 50


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@testrct;

If you want to reach data in recettes from testrct, you should create a link
this this:
connect sbm/sbm@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@sbm.mc> wrote in message
news:9aeonf$2nc$1@news2.isdnet.net...
> Hi,
>
> I have two oracle databases (recettes and testrct) and a user SBM for each
> database
>
> SQL> connect sbm/sbm@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@testrct
> Connecté.
>
> SQL> select * from brigade@testrct;
> select * from brigade@testrct
>                       *
> ERREUR à la ligne 1 :
> ORA-02085: lien de base de données TESTRCT se connecte à RCT
>
> Some one could help me
>
> Thank's
>
>