Chanchal Wankhade wrote:Really !!! The Same Link Posted Twice :)
Hi,Visit the path below. Well explain,,,
select * from dba_db_links;
user10978624 wrote:Do you have in a table in your DB a list of all remote DBs that can connect to your DB?
dba_db_links will give me all db_links which we have created in our schema for connecting to other database.
But i am looking for all the dblinks which other schema/databases are using to connect to my schema/database?
Osama_mustafa wrote:That tells about db links defined in the database. It says nothing about who is connecting to the database via a db link, which appears to be what the OP is asking about.
you could check