Home » RDBMS Server » Server Administration » finding private and public db_links (Oracle 11.2.0.2 Solaris)
finding private and public db_links [message #538841] Mon, 09 January 2012 12:13 Go to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
Is there a query I can use to find all private/public db_links
within a DB? If owner in dba_dba_links has a name can I assume
that the link is private and owned by that user?


select owner, db_link from dba_db_links;



If that is the case, how can I find public DB_LINKS

Thanks to all who answer
Re: finding private and public db_links [message #538843 is a reply to message #538841] Mon, 09 January 2012 12:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> select owner from dba_db_links;

OWNER
------------------------------
PUBLIC
USER1
USER1

Re: finding private and public db_links [message #538844 is a reply to message #538843] Mon, 09 January 2012 12:24 Go to previous message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
thanks
Previous Topic: Verify Tablespace space
Next Topic: more than one report server for performance
Goto Forum:
  


Current Time: Fri Mar 29 08:06:46 CDT 2024