Oracle: export/import using compressed file

Export to the compressed file

/etc/mknod my_own_pipe p
gzip -c -9 < my_own_pipe > mydump.gz &
exp username/password ...... file=my_own_pipe
rm -f my_own_pipe

Import from a compressed file:

/etc/mknod my_own_pipe p
uncompress < mydump.Z > my_own_pipe &
imp username/password ....... file=my_own_pipe
rm -f my_own_pipe

Topics: Oracle, Unix Shell, export/import | Submitter: checkthis

Comments

You must be logged in to post a comment.