This discussion is archived
6 Replies Latest reply: Jan 25, 2013 1:51 PM by Srini Chavali-Oracle RSS

public database link username

gamalraj Newbie
Currently Being Moderated

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 connect to targetuser idenitified by targetpassword using '';

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



  • Correct Answers - 10 points
  • Helpful Answers - 5 points