Re: Database link in Oracle8

From: Joe Long <joe.long_at_cticallcenter.com>
Date: Wed, 29 Sep 1999 00:54:11 -0500
Message-ID: <37F1A983.13486C03@cticallcenter.com>

Try making the name of the link the same as the SID of the remote database. Hope it helps.

Joe Long

"Miguel Sánchez" wrote:
>
> 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?
Received on Wed Sep 29 1999 - 00:54:11 CDT