Re: I've a problem with the DATABASE LINK

From: PIERRE HIRTH <phirth_at_club-internet.fr>
Date: Wed, 4 Apr 2001 21:54:32 +0200
Message-ID: <9afu55$qv$1@front4.grolier.fr>

It is for the solution that I waited thank you.

  David Busby <dbusby3_at_slb.com> a crit dans le message : 3ACB0D3D.F5921A20_at_slb.com...
  Try doing the same statement but use CREATE PUBLIC   Pierre HIRTH 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

--

Received on Wed Apr 04 2001 - 14:54:32 CDT