How to get Oracle database directories details

 Get Oracle Database directories details

SQL> desc dba_directories;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 OWNER                                     NOT NULL VARCHAR2(128)

 DIRECTORY_NAME                            NOT NULL VARCHAR2(128)

 DIRECTORY_PATH                                     VARCHAR2(4000)

 ORIGIN_CON_ID                                      NUMBER

set linesize 190

col owner for a30

col directory_name for a30

col directory_path for a50

select owner,directory_name,directory_path from dba_directories;

If you want to create a directory - 

create or replace directory directory_name as 'file_name';

grant read,write on directory_name  to user;