Oracle Directories Report
This script displays information about all Oracle directory objects defined in the database. It queries the DBA_DIRECTORIES view to show directory owner, name, and filesystem path, helping DBAs review external directory configurations used for file operations.
oraclesqlreporting-analyticsv1.0.0
0 stars0 downloads15 views0 comments
By OracleDba • Created
Code
(17 lines)1234567891011121314151617
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/directories.sql
-- Author : Tim Hall
-- Description : Displays information about all directories.
-- Requirements : Access to the DBA views.
-- Call Syntax : @directories
-- Last Modified: 04/10/2006
-- -----------------------------------------------------------------------------------
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;