← 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