RE: Source for DB links

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Tue, 31 Jul 2001 11:06:29 -0700
Message-ID: <F001.0035AA90.20010731111631@fatcity.com>

Another script:

set linesize 120

column db_link format a20
column username format a15
column host format a20
column owner format a20
select * from global_name;
select * from dba_db_links;
clear columns

MOHAMMAD RAFIQ Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 31 Jul 2001 10:28:15 -0800

SELECT d.owner, d.db_link, d.username,d.host, d.created, l.password FROM dba_db_links d, sys.link$ l, dba_users u WHERE d.db_link = l.name
AND d.owner = u.username
AND l.owner# = u.user_id;

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

George A.
Sent: Tuesday, July 31, 2001 11: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: 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

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--

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

Author: Mohammad Rafiq
INET: rafiq9857_at_hotmail.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