Compressed Export and Import

Export:

Description:

i. datetime=` date +"%y%m%d_M%S"`


ii. mknod /home/oracle/aakash/devrelease/Exp_Pipe_Test/exp_pipe p


iii. gzip -cNf /home/oracle/aakash/devrelease/Exp_Pipe_Test/bstbuy_lkup_$datetime.dmp.gz &


iv. exp username/password file=/home/oracle/aakash/devrelease/Exp_Pipe_Test/exp_pipe compress=y rows=y tables=CMGT_TASK buffer=8192000 log=/home/oracle/aakash/devrelease/Exp_Pipe_Test/bstbuy_lkup_$datetime.dmp.log


v. rm -f /home/oracle/aakash/devrelease/Exp_Pipe_Test/exp_pipe


Import:


Description:



i. datetime=` date +"%y%m%d_M%S"`


ii. mknod /home/oracle/aakash/devrelease/Exp_Pipe_Test/imp_pipe p


iii. gunzip -c bstbuy_lkup_090102_100114.dmp.gz >/home/oracle/aakash/devrelease/Exp_Pipe_Test/imp_pipe &


iv. imp username/password file=/home/oracle/aakash/devrelease/Exp_Pipe_Test/imp_pipe full=y ignore=y buffer=1024000 commit=y log=/home/oracle/aakash/devrelease/Exp_Pipe_Test/imp_bstbuy_lkup_$datetime.log


v. rm -f /home/oracle/aakash/devrelease/Exp_Pipe_Test/imp_pipe