• 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
remap_schema='SCOTT:SCOTT'

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
Username=scott/tiger
tables=scott.emp
directory=EXP_DIR
dumpfile=QUERY_EXP.dmp
logfile=QUERY_EXP.log

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?


Yes


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 Backups using Shell Scripts

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

Feedback