Query To Get List of Database Directories

Download(dbdir.sql)

REM +======================================================================+
REM                    
REM File Name: dbdir.sql
REM 
REM Description:
REM   Query To Get List of Database Directories 
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @dbdir.sql
REM   
REM +======================================================================+

clear columns
set lines 180
set pages 100
col OWNER for a12
col DIRECTORY_NAME for a40
col DIRECTORY_PATH for a80 WORD_WRAPPED

select * from dba_directories;