Re: Compressing export on the fly using Oracle's zip command

From: Palooka <nobody_at_nowhere.com>
Date: Sun, 31 Aug 2008 18:50:48 +0100
Message-ID: <TRAuk.142834$Ft5.137413@newsfe29.ams2>

zigzagdna_at_yahoo.com wrote:

> On Aug 28, 6:27 am, Cristian Cudizio <cristian.cudi..._at_yahoo.it>
> wrote:

>> On 28 Ago, 02:26, zigzag..._at_yahoo.com wrote:
>>
>>
>>
>>
>>
>>> I am on 10.2.0.3 on HP UNIZ 11i
>>> I have been compressing my exports using pipe mechanism using gzip on
>>> UNIX.
>>> /etc/mknod $PIPE_NAME p
>>> /usr/contrib/bin/gzip < $PIPE_NAME > $BackupExportFile &
>>> exp system/$pqmsSYSTEM_PSWD file=$PIPE_NAME log=$TLOGFILE consistent=Y
>>> \
>>> full=yes constraints=y compress=N >> $LOGFILE 2>&1
>>> Everything works. Instead of using gzip, I want to user Oracle’s zip
>>> command, however, Oracle’s zip does not work. This zip is expecting a
>>> file and apparently cannot read from pipe. Why?
>>> I did a test outside of export, use UNIX cat caommand, that also did
>>> not work.
>>> Any ideas on how to make it work. I rather use Oracle's zip than gnu's
>>> zip. I can send zip file to my venor who has databas eon Widnows and
>>> not used to gunzip.
>> i'm not able to decompress gzipped files with winzip too, however
>> there is gunzip for windows. Zip on the fly does not work because gzip
>> i able to read from stdin while zip not.
>>
>> Regards,
>> Cristian Cudizio
>>
>> http://cristiancudizio.wordpress.com- Hide quoted text -
>>
>> - Show quoted text -

> 
> Cristian:
> 
> Thanks a lot. I will have to give up on on the fly compression using
> zip because it did not work. Yes, I cn download
> gunzip for Windows.
> 
> Prem

A bit late to the party, sorry. 7zip for Windows will also solve your problem.

Palooka Received on Sun Aug 31 2008 - 12:50:48 CDT