DBlink

  • From: "Srinivas T" <SrinivasT@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Sep 2004 17:38:28 +0530

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@KPIT;
SELECT * FROM EMP@KPIT
                  *
ERROR at line 1:
ORA-12154: TNS:could not resolve service name


Help .. and thanks in advance....

Srinivas

--
//www.freelists.org/webpage/oracle-l
  • Follow-Ups:

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2004