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';





S5 Box