Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Compressing Export Dumps

Re[2]: Compressing Export Dumps

From: Sergey V Dolgov <>
Date: Thu, 16 May 2002 18:18:19 -0800
Message-ID: <>

Hello Simon,

The command mknod p does the same thing as mkfifo (it just calls mknod p).
I did large exports many times using gzip. So, it's your decision whether to use compress or gzip. I did not have any troubles at all. You don't have to remove the pipe and can easily reuse it whether you want.

Thursday, May 16, 2002, 8:43:25 PM, you wrote:

SW> Sergey,
SW> Thanks for the mkfifo idea. I've also come across "mknod myfifo p;compess < myinfo >> myinfo.Z"

SW> I'm looking at the two options, yet to ascertain whether second method works
SW> with gzip.
SW> Do you know of any known troubles (Block/File corruption) with first method ?
SW> Do I have to "rm yourinfo" or I can re-use the piping file ( as in ascript) ?

SW> Thanks once again,
SW> Simon

SW> -----Original Message-----
SW> Sent: Thursday, May 16, 2002 2:48 PM
SW> To: Multiple recipients of list ORACLE-L

SW> Hello Simon,

SW> You can make it like this:

SW> mkfifo yourfifo
SW> gzip <yourfifo >outfile.dmp.gz &
SW> exp ... file=yourfifo
SW> rm yourfifo

SW> Thursday, May 16, 2002, 4:38:40 PM, you wrote:

SW>> Hi all,
SW>> My export dumps are too big (80 GB) for my filesystem and I'm looking for
SW> a
SW>> way 
SW>> to compress them on the fly -ie without taking *.dmp to disk first but
SW>> straight *.dmp.gz
SW>> Anybody with an idea on how to archive this ?
SW>> Thanking you,

SW>> ---
SW>> CSW  

Best regards,



Please see the official ORACLE-L FAQ:

Author: Sergey V Dolgov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 16 2002 - 21:18:19 CDT

Original text of this message