Re: Database Links

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Tue, 3 Oct 2000 11:53:17 -0700
Message-ID: <8rd9u9$6sb$1@spiney.sierra.com>

What I do is create the link, as you did, then look for Oracle's error message which tells me what the link name must be.

In your case:

drop database link casem_orcl_link;

create database link ORCL.WORLD
connect to CASEM identified by CASEM
using 'ORCL';

good luck.

"Evelyn Bolton" <boltmail_at_pacbell.net> wrote in message news:39DA2511.AE69703F_at_pacbell.net...
> I am having trouble creating a database link. I am running Oracle
> 8.1.5. When I use the syntax: create public database link
> casem_orcl_link connect to casem identified by casem using 'ORCL', I get
> the following error when trying to select records from a table in the
> remote database: ORA-02085: database link CASEM_ORCL_LINK connects to
> ORCL.WORLD. When I use the syntax: create public database link
> casem_orcl_link connect to casem identified by casem
> using 'ORCL.WORLD', I get the error: ORA-12154: TNS:could not resolve
> service name. Yet, when I log into the ORCL databse and create the same
> link to our TEST database, I don't get any errors. Any input would be
> appreciated.
>
> Evelyn Bolton
>
>
Received on Tue Oct 03 2000 - 13:53:17 CDT