Compress Export on Multiple Files
I want to run an export on unix(ksh shell) and compress the dump file while I am exporting. I did a search and found some information to do this:
1) Make the pipe
mknod /tmp/exp_pipe p
2) Compress in background
compress < /tmp/exp_pipe > export.dmp.Z &
cat p | compress > output.Z &
cat p > output.file & )
3) Export to the pipe
exp file=/tmp/exp_pipe userid=scott/tiger tables=X
What if I need more than one export file because the compressed file exceeds 2G?
IMHO, you really need to ask yourself why are you exporting if your COMPRESSED export file is bigger than 2G.
Anyway, you would start multiple pipes int he background and then use the files= parameter to exp along with the filesize= paramter set to something larger than 2G based on your compression ratio.
Click Here to Expand Forum to Full Width