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, Sergey mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).