The column that will tell you is called OWNER. If the OWNER column is
public, then it is a public synonym. If it is something else, it is
private.
>From: "Rishi Jain-R-2" <jain.r.2_at_pg.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Database Links
>Date: Tue, 30 May 2000 10:02:11 -0800
>
>
>Hi All..
>
>
>
> How can we find out whether a db link is a private or public..I
>tried
> looking into the view dba_db_links but it does not have a column
>which
> gives this information.
>
>
>
>Thanks
>
>Rishi J.
>
>
>--
>Author: Rishi Jain-R-2
> INET: jain.r.2_at_pg.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
Received on Tue May 30 2000 - 14:08:13 CDT
