DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001

    Question 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:

    Export command:
    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?

  2. #2
    Join Date
    Nov 2000
    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.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.