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

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

Published on 

Published 18th June 2025