Table of Contents

Oracle Database - Directory Object

How to

get the list of all directories

select * from ALL_DIRECTORIES;
OWNER DIRECTORY_NAME DIRECTORY_PATH
SYS DATA_DUMP_DIR_AIRLINE /mnt/data
SYS XMLDIR /u01/app/oracle/product/11.2.0/db/rdbms/xml
SYS DATAPUMP /u01/app/oracle/datapump
SYS DATA_PUMP_DIR /u01/app/oracle/admin/DIDB01/dpdump/
SYS ORACLE_OCM_CONFIG_DIR /u01/app/oracle/product/11.2.0/db/ccr/state

create a directory

create directory data_dump_dir as 'F:\Dumps';

Grant privileges

GRANT READ,WRITE ON DIRECTORY data_dump_dir to myUser1, myUser2;