SQL Script Database Link Listing

Updated: 01-Jun-1998
Version: 1.0

Description

This script lists all database link details, including the password of the remote database user. Handy if you have forgotton a database password.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

col owner form a15
col db_link form a20
col userpass form a25
col host form a15

set pages 20

spool dblink.lst

select u.name owner
,l.name db_link
,l.host
,l.userid||'/'||l.password userpass
from sys.link$ l, sys.user$ u
where l.owner# = u.user#;

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links