The New Home of Oracle-wiki.net
All things oracle...
A website for IT Professionals involved with Oracle database.
The following command details how to run a table only parallel datapump export.
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=MyOutputFiles%u.exp
LOGFILE=MyLogfile.log
EXCLUDE=statistics
PARALLEL=4
FILESIZE=1GB
CONTENT=DATA_ONLY
TABLES=
MyTableOwner.MyTable1,
MyTableOwner.MyTable2,
MyTableOwner.MyTable3,
MyTableOwner.MyTable4
Notes
The %u parameter in the export file name allows multiple files to be create. %u appends a number to the end of each file
The filesize parameter determs the maximum size of each output file. Useful if you have an OS size limit.
In this parameter file, only data is exported. Remove this line if DDL is required as well.
expdp MyDbaUser@MyTNS parfile=MyParfileName
Published onĀ
Published 18th June 2025