RE: Source for DB links

From: eric harrington <eharrington_at_ecora.com>
Date: Tue, 31 Jul 2001 14:29:01 -0700
Message-ID: <F001.0035B2F6.20010731142618@fatcity.com>

Good point. I have tested the following to capture both PUBLIC and private db links.

set linesize 500;
set pagesize 1000;
column owner format a20;
column link_name format a20;
column userid format a20;
column host format a20;
column password format a20;
SELECT u.name owner, l.name link_name, l.userid, l.host, l.ctime created, l.password
FROM sys.link$ l, sys.user$ u
WHERE l.owner# = u.user#;

-----Original Message-----

Michael
Sent: Tuesday, July 31, 2001 2:28 PM
To: Multiple recipients of list ORACLE-L

This will only give you the public database links. You will also need to log in as the schema that owns the private database link, if that's the case, and look at user_db_links.

--Michael

-----Original Message-----

Sent: Tuesday, July 31, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L

dba_db_links

-----Original Message-----

Sent: Tuesday, July 31, 2001 10:48 AM
To: Multiple recipients of list ORACLE-L

All,
Where is the source for database links stored ? Perhaps, another to state my question is:How can I fully reconstruct a database link ?

TIA Al Rusnak
804-734-8453
rusnakga_at_hqlee.deca.mil

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rusnak, George A.
INET: rusnakga_at_hqlee.deca.mil

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.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

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: eric harrington
INET: eharrington_at_ecora.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