Expdp

oracle export exp expdp

See all directories

1
SELECT * FROM all_directories ORDER BY directory_path;

Create a new directory and grant access

1
2
CREATE OR REPLACE DIRECTORY EXPORT_DIR AS '/u01/export/';
GRANT READ, WRITE ON DIRECTORY test_dir TO XXX;

Export a schema

1
expdp system/password@sid schemas=XXX directory=EXPORT_DIR dumpfile=XXX.dmp logfile=XXX.log parallel=3

Export a database

1
expdp system/password@sid full=Y directory=EXPORT_DIR dumpfile=XXX.dmp logfile=XXX.log parallel=3

Kill a expdp job

1
2
expdp system/password@sid attach=SYS_EXPORT_SCHEMA_01
Export\> KILL_JOB

If you get an error that looks like this

1
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

then use a wildcard with the name of the dump file which will produce multiple files. Example:

1
expdp system/password@sid schemas=XXX directory=EXPORT_DIR dumpfile=XXX_%U.dmp logfile=XXX.log parallel=3