Re: Database Links
Date: Tue, 3 Oct 2000 20:59:26 +0200
Message-ID: <8rdae0$nmd$1_at_news.ost.eltele.no>
Look at Global Naming in your Init.ora
global_name = TRUE - enforce that a dblink has same name as the db it
connect to.
global_name = FALSE - will probable solve your trouble
Hope this helps.
):Hans N., Norway
"Evelyn Bolton" <boltmail_at_pacbell.net> wrote in message
news:39DA252B.CD8F257_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 - 20:59:26 CEST