Import dump using pipe



Background:


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…



No comments:

Post a Comment

Popular Posts