Export / Import in Unix

Why we use par file to Export / Import in Unix Boxes?

Let me go with my ways that I always try to get best out with quick results and solutions.

Advantages:

Super Users in UNIX can grep (I suppose) the running process if you use the exp/imp commands from command line. The way out is, use the parfile

Hides your password for system or for particular user with whom you are doing Export/Import

How:

Very simple

$ vi imp_pfile

userid=system/password@proddb
file=/u01/export/restore/exp_proddb.dmp
fromuser=prod
touser=prod
ignore=y
commit=y
buffer=10000000
log=/u01/export/restore/imp_proddb.log
feedback=1000000

Once done exit from the edition
:wq

and at the prompt go with this

$imp parfile=imp_pfile

This solves your issue…

and if you want to run the same in Unix background – you use nohup

$ nohup imp parfile=imp_pfile

** This is same for Export.