DBlink 2004-09-29 - By Ron Rogers
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@(protected) > 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@(protected);
SELECT * FROM EMP@(protected)
*
ERROR at line 1:
ORA-12154 (See ORA-12154.ora-code.com): TNS:could not resolve service name
Help .. and thanks in advance....
Srinivas
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
|
|
