where is my database link listed?
$ 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
Leave a Reply