Re: DBlink
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <SrinivasT@xxxxxxxxxxxxxxx>
- Date: Wed, 29 Sep 2004 08:23:02 -0400
What does the tnsnames.ora have to say about 'KPIT' ?
It looks like it could not resolve it to a database connection.
Ron
>>> "Srinivas T" <SrinivasT@xxxxxxxxxxxxxxx> 09/29/2004 8:08:28 AM >>>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
