How to Run a Parallel Datapump Table Only Export
Introduction
The following command details how to run a table only parallel datapump export.
Create the Following Parameter File
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.MyTable4Notes
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.
How to Use the Parameter File
expdp MyDbaUser@MyTNS parfile=MyParfileName
