where is my database link listed?

$ sqlplus scott/tiger@DEVL
SQL> select * from all_db_links;
no rows selected
SQL> select * from dual@PROD;

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;


3 Replies to “where is my database link listed?”

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

Leave a Reply