Wednesday, March 5, 2008

Compressing and splitting large exports in Unix

Mention in the parfile for the export as (pipe)
file=compress_pipe

Create pipes, one for compression and another for splitting :
rm –f compress_pipe
rm –f spilt_pipe
mknod compress_pipe p
mknod split_pipe p
chmod g+w compress_pipe
chmod g+w split_pipe

split –b500m < split_pipe > /tmp/exp_tab &
compress < compress_pipe > split_pipe &

exp parfile=export_tab.par file=compress_pipe > exp_tab.list 2>&1 &

Execute the reverse for import :
cat xaa xab xac xad > join_pipe &
uncompress –c join_pipe > uncompress_pipe &
imp file=uncompress_pipe

No comments: