| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Compressing Export Dumps
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,
Sergey mailto:dsv_at_pptus.oilnet.ru
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sergey V Dolgov
INET: dsv_at_pptus.oilnet.ru
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: ListGuru_at_fatcity.com (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
 |
 |