Oracle 12c: ALL_SYNONYMS excludes Objects behind DB_LINKs
Date: Wed, 8 Jul 2015 14:53:46 +0200
Message-ID: <d029dc6a77308ff8f38eb7bedbe9fa77.webmail_at_mx1bln1.prossl.de>
Dear fellows of the Oracle,
currently I have to deal with a customer's application that broke after migrating from 11.1.0.7 to 12.1.0.2. The issue is, that the app gets an object list from ALL_SYNONYMS expects some objects that are on a remote DB. In 12c, this query doesn't return the expected rows anymore.
Looking closer at the ALL_SYNONYMS DDL, it shows an additional "WHERE
db_link IS NULL" in two places. This wasn't there in 11.1 (I don't have
11.2 at hand currently).
WTF?!
Searching MOS and Google, I haven't found any clue so far what made Oracle
do this. I can only guess that this was added for security reasons.
Does anyone know more about Oracle's reasoning behind this? Or, even better: Do you have a documentation pointer for me?
Kind regards,
Uwe
--
http://oraculix.com/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 08 2015 - 14:53:46 CEST