How to find available directory objects on Oracle 11g system

Question

I assume this information is available in Oracle metadata tables  but where exactly    I need the directory object for BFILENAME as in this answer  Using PL SQL how do you I get a file  39 s contents in to a blob   I tried   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   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

User · Accepted Answer

The ALL DIRECTORIES data dictionary view will have information about all the directories that you have access to   That includes the operating system path   SELECT owner  directory name  directory path   FROM all directories

[oracle] How to find available directory objects on Oracle 11g system?

Examples related to oracle

Examples related to metadata

Examples related to oracle11g