Home » SQL & PL/SQL » SQL & PL/SQL » How do I get a list of databases that have a DB_LINK to my source database
How do I get a list of databases that have a DB_LINK to my source database [message #18463] Thu, 31 January 2002 15:55 Go to next message
Hoiwai
Messages: 1
Registered: January 2002
Junior Member
Hi Experts,

I have logged in to an Oracle 8 database. I can get a list of databases that I have db_link to by select * from ALL_DB_LINKS.

Is there a way to get a list of databases that have a db_link to my database?

Thanks!

Report message to a moderator

Re: How do I get a list of databases that have a DB_LINK to my source database [message #18490 is a reply to message #18463] Fri, 01 February 2002 10:36 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
No, I don't know of any way, because the remote DB doesn't have to connect to your DB to create a DB link. Their DB link could remain unused for years. You could look in your server's sqlnet.log for the source of incoming connections for some ideas.
I wrote some pl/sql to help display the links between different users between different database, but you need to visit each DB which could have links into your DB to get the details of those links.

Report message to a moderator

Previous Topic: PROS AND CONS: schema vs database
Next Topic: Report error from an insert and rollback
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 25 00:22:20 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.