How to Use the Oracle 12c Data Pump with a Parameter File

A parameter file is a text file listing the parameters for Oracle 12c’s Data Pump Export or Import and setting the chosen values. Data Pump Export and Import parameter files are constructed the same way.

Follow these steps to run a Data Pump Export with this parameter file:

Type the parameter file into a text editor and save it to a directory.

This example is a parameter file that exports the DEPARTMENTS and EMPLOYEES tables of the HR schema:

Create a parameter file that imports the data into a new user in its own tablespace.

In this example, HR2 is imported to its own tablespace, HR2_DATA.

Because this export is only a partial piece of the HR data model, you exclude constraints and triggers; they have dependent objects that aren’t in the export dump file. You don’t have to exclude them, but you get an error in the log file as Data Pump tries to create them.