User Tools

Site Tools


database:oracle:oracle_data_pump

This is an old revision of the document!


Oracle export/import database

Dump an oracle database on multiple files

$ expdp system/******** logfile=exp_pdco1mob00_full_12232013.txt directory=ABC dumpfile=exp_pdco1mob00_full_1_12232013.dmp,exp_pdco1mob00_full_2_12232013.dmp,exp_pdco1mob00_full_3_12232013.dmp,exp_pdco1mob00_full_4_12232013.dmp full=y exclude=statistics filesize=5g

DUMPFILE=expdir:exp%U.dmp

FILESIZE=2G

This will create multiple dmp files. As one dmp files grows past the 2 gigabytes filesize, a second dmp file till be created, and so on, all multiple dmp files being stored in 2 gigabyte chunks.

Import exported database with multiple files

$IMPDP directory=ABC dumpfile=exp_pdco1mob00_full_1_12232013.dmp,
exp_pdco1mob00_full_2_12232013.dmp,
exp_pdco1mob00_full_3_12232013.dmp,
exp_pdco1mob00_full_4_12232013.dmp 
logfile=IMPORT_DUMP full=y
database/oracle/oracle_data_pump.1699985982.txt.gz · Last modified: 2023/11/14 19:19 by manu