how to find target host name when using db link
Hi Team,
We have migrated databases to one server to other server from 11.1 to 11.2.0.4. Also we have lot of dblinks using in old.
Also they have access for dba_db_links.
So customer asking is there any way to find target host name when using db link?
My testing will involve using the application account and actually *use* the dblink to confirm which system is being targeted.
Is there some other command that is available to all users to verify the hostname of the target system (when using dblink) ?
Please provide any view or query to find the target host name when using db link?