Oracle Database - Directory Object

> Database > Oracle Database

2 - How to

2.1 - 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
Advertising

2.2 - create a directory

CREATE directory data_dump_dir AS 'F:\Dumps';

2.3 - Grant privileges

GRANT READ,WRITE ON DIRECTORY data_dump_dir TO myUser1, myUser2;
db/oracle/directory.txt · Last modified: 2017/09/06 19:28 by gerardnico