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

    public database link username

    gamalraj
      Gentlemen,

      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.

      e.g.,

      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.

      Thanks