Hi,
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
connected.
SQL> create databae link etslink connect to system
identified by pw using 'ETS';

SQL> /

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.


Cheers,