6 Replies Latest reply on Jan 25, 2013 9:51 PM by Srini Chavali-Oracle

    public database link username


      I would like to recreate the public database links with new username and password. Prior to that, I want to know which user the current public database link in connecting to.

      The dba_db_links table shows only the user name for private database links. Where can I find the username for public database link.


      SQL> create public database link abc.domain.com connect to targetuser idenitified by targetpassword using 'abc.doman.com';

      Where I find the information about targetuser; it is not shown in dba_db_links table for public database links.