OraFAQ Forum: Networking and Gateways » Find list of database links

Home » RDBMS Server » Networking and Gateways » Find list of database links (Oracle11.1.0.7.0, Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Find list of database links [message #514194]

Sat, 02 July 2011 10:30

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

There is a user account called 'BALA' in my database.I want to find out the database links that uses this 'BALA' account.

can somebody advice me how to find this ?

Thanks

Report message to a moderator

Re: Find list of database links [message #514206 is a reply to message #514194]

Sat, 02 July 2011 11:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>There is a user account called 'BALA' in my database.I want to find out the database links that uses this 'BALA' account.
>can somebody advice me how to find this ?

query DBA_DB_LINKS in every Oracle DB on this planet

Report message to a moderator

Re: Find list of database links [message #514217 is a reply to message #514206]

Sat, 02 July 2011 12:19

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thank you ..

Report message to a moderator

Previous Topic:	unable to connect to a database
Next Topic:	ORA-12154:TNS:could not resolve the connect identifier specified

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 02 09:52:34 CDT 2026