I'm using Oracle 8.1.7 with Solaris 2.6. I am not able to select data using a db link. Heres what i've done - Using SQL client for WinNT.
SQL> conn system/pw@srv
SQL> create databae link etslink connect to system
identified by pw using 'ETS';
Database link created.
SQL> select * from dba_tables@etsllink;
select * from tab@etsvollink
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
I have both the DB settings set up in TNSNAMES.ORA and am not using SQLNET.ORA. Secondly, I'm able to ping to the other server as well. What could b the problem ? I can also connect to both the DBs without DB link.
Click Here to Expand Forum to Full Width