-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- 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;