How to Export and Import Using Parameter file ( Parfile ). /* Step By Step */
My Today's Scenario How to use parfile in Export and Import. Parfile export and Import used .par extension.
Suppose Export command is very lengthy that case we create a
parfile.
In this file we write a Export command and file extension is .par
File name= exp_scott.par
-----------------------------------------------------------------------------------directory=mydump logfile=scott_exp.log dumpfile=scott_exp.dmp schemas='SCOTT'exclude=table:"IN('EMP','DEPT')"