Simple question on DB LINKS
Hello Gurus..
I created a db link like this.
create public database link my_link connect to home_office identified by home using 'j2ee';
Link is created successfully. and i was able to connect to the database. Now when i remove my tnsnames entry for that DB on my work station, the Link doesn't work.
So my question is
1) do we need to have tnsnames entry to the database for which i created the link ?. is so, then what is the point in creating a link, i can as well type
home_office/home@j2ee.
i just dont understand this thing. can anyone shed some light on where iam getting it wrong. really appreciate it.
Thanks