dba_directories_specified_owner.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : List database directories of specified schema owner in the database order by directory_name.
-- Call Syntax  : @dba_directories_specified_owner.sql
-- Last Modified: 20/06/2017
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN OWNER FORMAT a30
COLUMN directory_name FORMAT a30
COLUMN directory_path FORMAT a100
SELECT *
FROM dba_directories
WHERE OWNER=UPPER('&owner')
ORDER BY
  OWNER,
  directory_name;