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:
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-lReceived on Mon Mar 03 2014 - 20:34:01 CET