How to utilize PARFILE parameter in DATAPUMP Exports and Imports

Hello Everyone,

In this article , we will learn  how to utilize PARFILE parameter in DATAPUMP Exports and Imports.

what is parfile ?

Parfile is a parameter in datapump exports  and imports . The name of the parfile  can give in any format but extension should be .par .  

We can  make a simple text file anywhere you want in your system and name it as  filename.par.

DATAPUMP Export  using PARFILE:

create a sample text file with the extension .par  , and include all the parameters which we use for export operation

After creating the parameter file you can  execute the expdp export utility using PARFILE parameter.

Export completed successfully .

Note: We cannot write login information of the database user in Parameter file.

Dataump  import using Parfile.

create different parfile for import.

Now perform IMPDP utility using  above PARFILE parameter.

Thank you for giving your valuable time to read the above information.

Follow us on 
Website :  www.ktexperts.com
Facebook Page : KTexperts
Linkedin Page : KT EXPERTS