Re: database link not working

Hi!

What it's trying to say is that the database you're trying to connect to is called 'ORACLE'.

Regards

Zeth

Timo Biesenbach wrote:

> 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 Fri Jul 23 1999 - 08:08:24 CDT