Home » RDBMS Server » Networking and Gateways » Find list of database links (Oracle11.1.0.7.0, Unix)
Find list of database links [message #514194] Sat, 02 July 2011 10:30 Go to next message
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
Re: Find list of database links [message #514206 is a reply to message #514194] Sat, 02 July 2011 11:02 Go to previous messageGo to next message
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
Re: Find list of database links [message #514217 is a reply to message #514206] Sat, 02 July 2011 12:19 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Thank you ..
Previous Topic: unable to connect to a database
Next Topic: ORA-12154:TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Fri Mar 29 03:00:46 CDT 2024