Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: database link

Re: database link

From: bjin <jinbo_at_hpsgns1.sgp.hp.com>
Date: Tue, 23 Mar 1999 14:24:46 +0800
Message-ID: <36F733AE.D6C2D302@hpsgns1.sgp.hp.com>


Try
create database link dlink connect to billusr01 identified by billusr01 using 'remotedb';

And make sure you have configured tnsnames.ora properly to include service name 'remotedb' which points to your remote database.

Hth
bjin

Ong Chin Hui wrote:

> Hi, I am trying to access a remote database using database link
> but I keep encountering hitting some error messages. I will be glad if
> someone could point out my mistakes or how to troubleshoot them.
>
> What I did:
>
> SQL> create database link dlink using 'billusr01/billusr01_at_remotedb';
>
> note: remotedb the SID of the remote database.
>
> SQL> describe user_tables_at_dlink;
> ERROR:
> ORA-12154: TNS:could not resolve service name
Received on Tue Mar 23 1999 - 00:24:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US