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)
How we can check all DB Link connections. [message #644892] Thu, 19 November 2015 06:59 Go to next message
msol25
Messages: 368
Registered: June 2011
Senior Member
Please help for getting command, how to check all db_link connections.
Re: How we can check all DB Link connections. [message #644893 is a reply to message #644892] Thu, 19 November 2015 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe you could try to do it before asking?

Re: How we can check all DB Link connections. [message #644894 is a reply to message #644893] Thu, 19 November 2015 07:08 Go to previous messageGo to next message
msol25
Messages: 368
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;


Re: How we can check all DB Link connections. [message #644897 is a reply to message #644894] Thu, 19 November 2015 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
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.

Re: How we can check all DB Link connections. [message #644902 is a reply to message #644892] Thu, 19 November 2015 08:52 Go to previous messageGo to next message
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
Re: How we can check all DB Link connections. [message #644904 is a reply to message #644902] Thu, 19 November 2015 09:14 Go to previous message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, 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:
  


Current Time: Sun Jan 21 03:46:53 CST 2018

Total time taken to generate the page: 0.01364 seconds