where is my database link listed?
October 6th, 2008
$ sqlplus scott/tiger@DEVL
SQL> select * from all_db_links;
no rows selected
SQL> select * from dual@PROD;
D
-
X
Hey, why does this work???
Ok, after some research I found out that this seems to be an implicit loopback database link. The fact that the DEVL database has the global name set to PROD is just to annoy more 
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------
PROD.LAURENTSCHNEIDER.COM
Laurent, btw the base is sys.link$
Grz
M
typing via an ipod is not easy…
The FQDN is derived from your sqlnet.ora during database install
it’s not the same as using a database link, because if using a dblink, a new connection (for the link) is created, which is not the case for above construct.