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