• Arun Kumar

Oracle EXPDP PAR File Example

When you work with Data pump, you have to specify the parameters both while exporting and importing. A sample data pump export and import looks like below:

Data Pump Export:
expdp directory=datapump dumpfile=scott_bkp.dmp logfile=scott_bkp.log schemas='SCOTT'

Data Pump Import:
impdp directory=datapump dumpfile=scott_bkp.dmp logfile=imp_schema.log

The above example is very simple and straight forward. But, in real-time, you might perform very complex export and import. It becomes very tedious job for DBA to type entire expdp/impdp command. Also, in some environments, you might perform same export and import maybe daily or weekly.

Expdp Parameter File

Data Pump jobs can be automated using PAR file. You basically create one par file which contains all the export or import parameters and just call the par file at expdp utility. A sample example of how par files works is below:

# cat exp.par

And! Its very simple to call the above export PAR file

# expdp parfile=exp.par

Frequently Asked Questions

What is parameter file?

Parameter file is simple text file which can be called by data pump utilities like expdp and impdp. This file can be created anywhere on the server and there is no need to involve the DBA

What is the parameter file naming convention?

You can specify any extension but it is recommended to use .par

What all can I specify in parameter file?

You can specify every parameter that you use with expdp inside the par file.

Can I use par file both while export and import?



Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir