← Space Management
Oracle · Space Management
How to list Oracle directory objects
List every Oracle DIRECTORY object with owner and physical filesystem path from DBA_DIRECTORIES.
Tested on11g12c18c19c21c23ai26ai
DBA_DIRECTORIES lists every DIRECTORY object — logical names used by external tables, UTL_FILE, Data Pump, and BFILE. Includes the owner and the filesystem path the directory points to.
SET LINESIZE 150
COLUMN owner FORMAT a20
COLUMN directory_name FORMAT a25
COLUMN directory_path FORMAT a80
SELECT *
FROM dba_directories
ORDER BY owner, directory_name;spacedirectorydba_directoriesexternal table