OraFAQ Forum: Server Administration » How we can check all DB Link connections.

Home » RDBMS Server » Server Administration » How we can check all DB Link connections. (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)

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

How we can check all DB Link connections. [message #644892]

Thu, 19 November 2015 06:59

msol25
Messages: 396
Registered: June 2011

Senior Member

Please help for getting command, how to check all db_link connections.

Report message to a moderator

Re: How we can check all DB Link connections. [message #644893 is a reply to message #644892]

Thu, 19 November 2015 07:05

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe you could try to do it before asking?

Report message to a moderator

Re: How we can check all DB Link connections. [message #644894 is a reply to message #644893]

Thu, 19 November 2015 07:08

msol25
Messages: 396
Registered: June 2011

Senior Member

Yes Michel:

I have done below mentioned sql queries:


select  *
from    all_db_links
where   db_link like '%TEST%'

select  *
from    all_tables@TEST
---where   owner not in('SYS','SYSTEM')

select  *
from    schema_name.table_name@db_link_name;

Report message to a moderator

Re: How we can check all DB Link connections. [message #644897 is a reply to message #644894]

Thu, 19 November 2015 07:11

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So what is the problem now?
You know how get all db links, you know how to check one, so you know how to check all: just loop the latter on the result of the former.

Report message to a moderator

Re: How we can check all DB Link connections. [message #644902 is a reply to message #644892]

Thu, 19 November 2015 08:52

bpeasland
Messages: 51
Registered: February 2015
Location: United States

Member

I typically just do:

select sysdate from dual@link_name;

So do this for each db link. Note that if the db link is private, you will have to be logged in as the owner.

HTH,
Brian

Report message to a moderator

Re: How we can check all DB Link connections. [message #644904 is a reply to message #644902]

Thu, 19 November 2015 09:14

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

SELECT 'SELECT * FROM GLOBAL_NAME@'||db_link||';'
FROM dba_db_links;

[Edit: closing semi-colon]

[Updated on: Thu, 19 November 2015 11:21]

Report message to a moderator

Previous Topic:	Cannot start Oracle -- unable to find file
Next Topic:	Is ASM a solution to a large recovery area

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 03:08:20 CDT 2023