dsdel, hum, what do you mean? select * from mylink ?
dsdel, it's not a table.. so I don't really know how to do it
SELECT * FROM emp@foo
dsdel, ok I think i got the issue
dsdel, the ORACLE_SID wasn't correctly set... Now I think I have issue with the datalink: i created the database link with sys and then created a symbolic link for the user I want to use the link... it doesn't work and I cant drop it either :) (hard to be a newbie)
dsdel, I can see the synonym here: select * from synonyms where sname like '%OWN%'; but I can't drop it nor with sys (myUser.synonymName) nor with the myUser
dsdel, ah.. ok solved this.. the owner was "sys"