I've a problem with the DATABASE LINK

From: Pierre HIRTH <p.hirth_at_sbm.mc>
Date: Wed, 4 Apr 2001 11:14:58 +0200
Message-ID: <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_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 - 04:14:58 CDT