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

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 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

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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 06 03:19:35 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.