database link not working

From: Timo Biesenbach <tbiesenb_at_igd.fhg.de>
Date: Thu, 22 Jul 1999 16:04:35 +0200
Message-ID: <379724F3.E5378C93@igd.fhg.de>

Hi !

I have two Oracle 8i instances running on two different computers. To simplify data exchange between them I tried to create a database link between them :

SQL> create database link edesign0.igd.fhg.de connect to test identified by test using 'edesign0';
Database link created.

But when I try to get data from the remote computer : SQL> select * from types_at_edesign0.igd.fhg.de; select * from types_at_edesign0.igd.fhg.de

                    *

ERROR at line 1:
ORA-02085: database link EDESIGN0.IGD.FHG.DE connects to ORACLE

What could be the problem here ? And what is this message supposed to say ? Of course I am trying to connect to Oracle...

It says in the docs that the name of the link must be identical to the global name of the remote database. That is true in my case.

Any help appreciated,
-timo
--
+---+---+-+-+-+-+

|   |   |-+-+-+-+ Fraunhofer-Institut fuer Graphische Datenverarbeitung

+---+---+-+-+-+-+ Fraunhofer-Institute for Computer Graphics
| | |-+-+-+-+ Abteilung / Department : Document Imaging
+---+---+-+-+-+-+

|      __   _   | Timo Biesenbach
|  !  ! _  ! \  | Rundeturmstr. 6      phone  ++49 6151 155 578
|  !  !__! !_/  | 64283 Darmstadt      fax    ++49 6151 155 299 
+---------------+ Germany              email  timo.biesenbach_at_igd.fhg.de

Received on Thu Jul 22 1999 - 09:04:35 CDT