• 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

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis