Re: export WITH compress

No, I've never used a pipe, either, but that's the technique you're probably going to have to use -except that it will be compressing the output of the pipe as it happens, not the file before the one currently being produced.

Check out the Co-operative FAQ at Jonathan Lewis's web site (can't remember the address off-hand, but it's linked on the 'Other Resources' page of my own site, link below) for an answer about this by Norman Dunbar (from memory, the article is called something like 'how do I export when the dump file is too big?'). The treament of pipes is not maybe as in depth as you'd like, but I could work out the principles (and for a Windows User that's not a bad recommendation!).

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message
news:l3estt8vmu6l3rjssgjdqeov5dj7a82hsi_at_4ax.com...


> Hi,

> doing an export of my 8.1.7.1 DB on AIX 433-09 will result in a file

> greater than 1 GB. This seems to be larger than allowd.

> So i defined export to use multiple output files with a maximum size

> of 500M each. Now it works, producing 3 files.

> The first version of my export script does a compress after the export

> has finished to save disk space.

> How can i compress (or zip or gzip, whatever gives better results)

> while export is still running, so file1 is compressed before or while

> export writes to file2 ?

> Maybe this could be done by a 'pipe' ? But i've never used a pipe

> in unix!

>

> Many thanks

> Andreas

> Andreas Wizemann