SQL Script Database Link listing

Updated : 1-June-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

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

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal