DBlink

From: Srinivas T <SrinivasT_at_KPITCummins.com>
Date: Wed, 29 Sep 2004 17:38:28 +0530
Message-ID: <4A1BE23A7B777442B60F4B4916AE0F130292FE18@sohm.kpit.com>

Hi friends,
I am having the following problem while selecting data trhu the dblink

My oracle version is 9.0.2 and I am creating dblink to the database version 8.1.7 ie KPIT.

CREATE PUBLIC DATABASE LINK KPIT CONNECT TO SCOTT IDENTIFIED BY TIGER USING 'KPIT'; Database link created.

But I am unable to see the remote data......

SQL> SELECT * FROM EMP_at_KPIT;
SELECT * FROM EMP_at_KPIT

                  *

ERROR at line 1:
ORA-12154: TNS:could not resolve service name

Help .. and thanks in advance....

Srinivas

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 29 2004 - 07:10:24 CDT