If dba_db_links.owner = 'PUBLIC' then it's a public database link.
Rishi Jain-R-2 wrote:
>
> 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).
Received on Tue May 30 2000 - 13:37:38 CDT
