Re: SYS_CONTEXT DBLINK_INFO returns null over db link

From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Mon, 3 Mar 2014 13:34:01 -0600 (CST)
Message-ID: <9e2bb28e92d0ed3da02d00a7d6c0010a.squirrel_at_society.servebeer.com>



Karth replies:

> Select property_value from Databae_properties_at_remotedb
> Where property_name='GLOBAL_DB_NAME';

That's going to get me the "target" information. I was looking for the "source" information, or what instance the DB link was coming from.

I've decided to switch tactics and perform an extra SELECT over the DB link instead of trying to figure out how to grab the remote link info.

Thanks!

Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 03 2014 - 20:34:01 CET

Original text of this message