hi

i create db_link ...(db_link created)
i use SELECT * FROM DEPT@db_link_name;

gives me error TNS:COULD NOT RESOLVE SERVICE NAME

i try to connect to remote db using ...
CONNECT USER/PWD@DB_NAME2 and i get connected
pls help me to fix this step by step please.....
what should i have on my tnsname.ora?example pls..

thank for help....