Compressing export on the fly using Oracle's zip command

[zigz...@yahoo.com]

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.

[sybr...@hccnet.nl]

On Wed, 27 Aug 2008 17:26:43 -0700 (PDT), zigz...@yahoo.com wrote:

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

Winzip can work with gzipped files.

--
Sybrand Bakker
Senior Oracle DBA

[Cristian Cudizio]

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

[zigz...@yahoo.com]

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

> 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

[Palooka]

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

Palooka