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 …> &
- 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