Compress Export on Multiple Files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Compress Export on Multiple Files

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    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 &
    -or-
    cat p | compress > output.Z &
    -or-
    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
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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