Re: Where, oh where, did my directory go?
Date: Tue, 14 Jul 2015 11:47:10 -0600
Message-ID: <55A54B1E.20800_at_gmail.com>
How confident are you that you are using the SAME container and container privs each time?
After all, SYS in a PDB does not have the same visibility as SYS in ROOT
/Hans
On 14/07/2015 7:51 AM, Sweetser, Joe wrote:
> I have dug a bit deeper with no resolution (will probably open an SR at some point) and just wanted to share what I found. The reason I found myself in this situation is that I have a script that queries dba_directories to find the path for a given directory_name. I then use that path later in the script. It's not critical and I can work around it but that is how I discovered this strange behavior in one of my 12c databases. Anyway, below is just a little more info.
>
> The view dba_directories is created with the below SQL:
>
> select OWNER, DIRECTORY_NAME, DIRECTORY_PATH, ORIGIN_CON_ID from INT$DBA_DIRECTORIES;
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 14 2015 - 19:47:10 CEST