Xref: alice comp.databases.oracle.tools:32563
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!newsfeed1.swip.net!swipnet!newsfeed2.funet.fi!newsfeed.uninet.ee!diablo.uninet.ee!not-for-mail
From: "Ivar Stolfot" <iff@online.ee>
Newsgroups: comp.databases.oracle.tools
References: <37ef787b.14422113@news.uned.es>
Subject: Re: Database link in Oracle8
Date: Tue, 28 Sep 1999 11:09:15 +0300
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Lines: 21
Message-ID: <37f0779b$0$26375@diablo.uninet.ee>
X-Trace: 938506139 26375 (none) 195.80.104.60

# Global Naming -- enforce that a dblink has same name as the db it connects
to
global_names = true
Should work if you set this "false" in init.ora file

Iff

Miguel S?nchez <msanchez@csi.uned.es> wrote in message
news:37ef787b.14422113@news.uned.es...
> I have been trying to create a database link for a schema in my
> database. In the creation it doesn't report any error, but when I used
> it the database issues the following message:
>
> "ORA-02085: database link ORAFRODO.WORLD connects to ORACLE.WORLD"
>
> The database link has the same name as the remote service (in
> tnsnames.ora file).
>
> What is wrong in my database configuration?