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.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.

How to Use the Parameter File

expdp MyDbaUser@MyTNS parfile=MyParfileName
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License