Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re[4]: Compressing Export Dumps

From: Sergey V Dolgov <>
Date: Sun, 19 May 2002 21:33:17 -0800
Message-ID: <>

Hello Simon,

I did such exports sequentially (using cron jobs) therefore i had no problems with it.
Try to look at locks maybe your sessions are blocking each other. Did you use parameter CONSISTENT=Y ?

Saturday, May 18, 2002, 6:03:18 PM, you wrote:

SW> Hi Sergey and all,
SW> Tried to impliment the on-the-fly gzip but some breakages!!
SW> I created 7 different pipes and 7 different export jobs.
SW> The first job run manually completed successfuly but all the 
SW> croned jobs are stuck -the daemon fired them off but nothing is taking place!
SW> The Log files are empty and the zipped dumps are no where to be seen!
SW> A "ps -ef|grep exp" shows that the jobs are active. It's now coming to 10
SW> Hrs.
SW> Any known issues with multi-occurences of pipe-files/gzip etc ?

SW> Thanks

SW> -----Original Message-----
SW> Sent: Friday, May 17, 2002 5:18 AM
SW> To: Multiple recipients of list ORACLE-L

SW> Hello Simon,

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

SW> 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
SW> <

myinfo >>> myinfo.Z"
SW>> I'm looking at the two options, yet to ascertain whether second method
SW> works
SW>> with gzip.
SW>> Do you know of any known troubles (Block/File corruption) with first
SW> method ?
SW>> Do I have to "rm yourinfo" or I can re-use the piping file ( as in
SW> 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
SW> 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 Mon May 20 2002 - 00:33:17 CDT

Original text of this message