title: How to find available directory objects on Oracle 11g system?
body: <p>I assume this information is available in Oracle metadata tables, but where exactly ?</p>
  
  <p>I need the directory object for <a href="http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/functions019.htm#i76871" rel="nofollow noreferrer">BFILENAME</a> as in this answer: <a href="https://stackoverflow.com/questions/122909/using-pl-sql-how-do-you-i-get-a-files-contents-in-to-a-blob/123051#123051">Using PL/SQL how do you I get a file&#39;s contents in to a blob?</a></p>
  
  <p>I tried:</p>
  
  <pre><code>select * from all_objects where object_type ='DIRECTORY';
  
  OWNER                  OBJECT_NAME
  ------------------------------ ------------------------------
  SUBOBJECT_NAME          OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
  ------------------------------ ---------- -------------- -------------------
  CREATED         LAST_DDL_TIME   TIMESTAMP       STATUS  T G S
  ------------------- ------------------- ------------------- ------- - - -
   NAMESPACE EDITION_NAME
  ---------- ------------------------------
  SYS                ORACLE_OCM_CONFIG_DIR
                      12689        DIRECTORY
  2010-03-30 10:16:30 2011-01-10 12:49:39 2011-01-10:12:49:39 VALID   N N N
       9
  
  SYS                DATA_PUMP_DIR
                      12764        DIRECTORY
  2010-03-30 10:16:43 2011-01-10 12:49:38 2011-01-10:12:49:38 VALID   N N N
       9
  
  SYS                XMLDIR
                      57134        DIRECTORY
  2010-03-30 10:29:37 2010-03-30 10:29:37 2010-03-30:10:29:37 VALID   N N N
       9
  </code></pre>
  
  <p>But based on the output timestamps these are not the dirs created for me. This also doesn't show what is the real OS filepath for the object.</p>