OraFAQ Forum: Replication » how can i see number of dblinks from the server side

Home » Server Options » Replication » how can i see number of dblinks from the server side

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

how can i see number of dblinks from the server side [message #240949]

Mon, 28 May 2007 00:42

vijaykumarsudi
Messages: 9
Registered: September 2006
Location: hyderabad

Junior Member

hi all,
how can i find the number of database links created to my database on the server side.on the client side i have views like dba_db_links and user_db_links but this can be run from client side,but i need to knw hw many links have been created to my database on terget side.
Thanks in advance
Vijay

Report message to a moderator

Re: how can i see number of dblinks from the server side [message #240955 is a reply to message #240949]

Mon, 28 May 2007 00:55

Frank Naude
Messages: 4571
Registered: April 1998

Senior Member

select * from dba_db_links@target;

Report message to a moderator

Previous Topic:	Multimaster Replication
Next Topic:	Replicate "Security management tables"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 08 04:54:20 CDT 2022