How to utilize PARFILE parameter in DATAPUMP Exports and Imports

Share via:

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.


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 
Facebook Page KTexperts
Linkedin Page : KT EXPERTS

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Add Comment