DBlink

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

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

Other related posts: