$ 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.