Import dump using pipe

Background:

Export dump compression using pipe

Same as export using pipe, import can be done by following below steps

Import using Pipe

Step1

Create nods equal to dump files & point it to a pipe

mknod /u01/orabak/export/imp_pipe1 p

mknod /u01/orabak/export/imp_pipe2 p

mknod /u01/orabak/export/imp_pipe3 p

Step2

Supply zipped dumpfiles to unzip commands against pipe

nohup gunzip -c /u01/orabak/export/exp_T2109_1.dmp.gz > /u01/orabak/export/imp_pipe1 &

nohup gunzip -c /u01/orabak/export/exp_T2109_2.dmp.gz > /u01/orabak/export/imp_pipe2 &

nohup gunzip -c /u01/orabak/export/exp_T2109_3.dmp.gz > /u01/orabak/export/imp_pipe3 &

  

Step3

Start Import

imp system file=/u01/orabak/export/imp_pipe1,/u01/orabak/export/imp_pipe2,/u01/orabak/export/imp_pipe3 fromuser=aradmin touser=ajay log=/u01/orabak/export/ixp_aradmin_T2109_zip.log

Executed…

Progress…