Oracle Database Directories - datapump

Create New Directory:

CREATE DIRECTORY dmpdir AS '/opt/oracle';

 

Set Permissions on New Directory:

GRANT read, write ON DIRECTORY dmpdir TO scott;

 

Oracle introduced a default directory from 10g R2, called DATA_PUMP_DIR, that can be used:

Show Current Directory:

SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';

 

DIRECTORY_PATH
--------------------------------------------------------------------------------
/home/oracle/app/oracle/admin/DBname/dpdump/

 

 

S5 Box

Login