Exp Imp Tips

Exp Imp Tips

4G file size limit

multi-file

exp file=(file1.dmp, file2.dmp …) filesize=4G <other options …>

pipe

$ mknod /tmp/exp_pipe p

$ exp file=/tmp/exp_pipe <other options …> &

  1. test dmp file size (in 512bytes block count)

$ dd if=/tmp/mypipe of=/dev/null

$ compress < /tmp/exp_pipe > export.dmp.Z &

tape volsize

$ exp file=/dev/rmt/0m volsize=4G

$ imp file=/dev/rmt/0m volsize=4G

raw device

$ exp file=/dev/rdsk/c0t3d0s0 volsize=4G

fasten exp speed

compress

direct path exp (about 30% shorter)

Make sure no other session operate database at the same time, otherwise database may be corrupted.

$ make -f $ORACLE_HOME/rdbms/lib/oracle.mk expst

$ make -f $ORACLE_HOME/rdbms/lib/oracle.mk impst