Wednesday, March 24, 2010

DB Links

DB Links
Query for getting DB Link name,password,username
========================================

set lines 1000
column Owner format a10
column DbLinkName format a30
column CONN_USER format a10
column CONN_PWD format a10
column CONN_STRING format a20


    * select l.name DbLinkName , du.username Owner ,l.userid CONN_User, l.password CONN_Pwd, l.host Conn_String from sys.link$ l,dba_users du where l.owner#=du.user_id (+)

----Public Link will have Owner as Null

    * select l.name Name , l.userid CONN_User, l.password CONN_Pwd, l.host Conn_String, l.ctime from sys.link$ l

1 comment:

Anonymous said...

TAHNKS FOR YOUR SHARING~~~VERY NICE.................................................