Originally posted by scansir
HI Jmodic

I just found the database link in Oracle schema manager.
Anyway, thx for your kindly help.

Dennis
Hi,

I have created a link thru scheme manager using system/manager as public. after this i am loggin into that user where i want to use this link. after giving command like

select * from mgisys2001.fnadvmem@MGIDATA2001;

in sqlplus it says TNS could not resolve service name & puts a * below MGIDATA2001. this is the link name.

do i need to give any rights to that user who wants to use this link. i have already made a public link.

km