« updatedb does not work with samba drives and cygwin
Oracle SQL Developer Data Modeling »

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

This entry was posted on Monday, October 6th, 2008 at 12:01 and is filed under oracle, sql, dba. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Post to : del.icio.us - Digg it - Furl - reddit - Spurl

Put your code in <code> and </code> tags

2 Responses to “where is my database link listed?”

  1. Marco Gralike Says:
    October 6th, 2008 at 22:57

    Laurent, btw the base is sys.link$

    Grz

    M

  2. Marco Gralike Says:
    October 6th, 2008 at 23:01

    typing via an ipod is not easy… :-)

    The FQDN is derived from your sqlnet.ora during database install

Leave a Reply

Use <code> and </code> to post code