RE: Where, oh where, did my directory go?

  • From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
  • To: "rjoralist3@xxxxxxxxxxxxxxxxxxxxx" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 26 Jun 2015 21:19:03 +0000

Me too! :)

FWIW, I also see the same behavior when connected as SYS.

-joe

15:15:02 pdb2> drop directory joe_dir;

Directory dropped.

15:15:21 pdb2> show user
USER is "SYS"
15:15:26 pdb2> create directory joe_dir as '/u04/oradata/backup/joe';

Directory created.

15:15:32 pdb2> select directory_name from dba_directories where directory_name
like '%JOE%';

no rows selected

15:15:38 pdb2> select object_name ||' - '|| object_type ||' - '|| created from
dba_objects where object_name like '%JOE%';

OBJECT_NAME||'-'||OBJECT_TYPE||'-'||CREATED
--------------------------------------------------------------------------------
JOE_DIR - DIRECTORY - 26-JUN-15
15:16:09 pdb2>

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rich Jesse
Sent: Friday, June 26, 2015 3:09 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Where, oh where, did my directory go?

Joe writes:

Without going into the details, I came across something strange in my
environments today. Basically, I have a 12c pluggable database where
a user-created directory does not show up in dba_directories. I have
another one where it works as expected. These are simply the single,
pluggable database that can be created without licensing the feature.
Utilities like data pump work as expected in both databases. I just
don't see an entry in dba_directories. There are undoubtedly
differences between the servers, notably the version of Linux. But I don't
know if that's any issue.

I see you're logged in as SYSTEM and the directory is owned by SYS. I'd have
thought that the SELECT ANY DICTIONARY of the DBA role would allow that to be
viewed, but I only have 11.2 here.

Just a thought...

Rich



--
//www.freelists.org/webpage/oracle-l


Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT, Underwriters
at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does
not guarantee that either are virus-free and accepts no liability for any
damage sustained as a result of viruses. Thank you.
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2015