Re: compression in a exp utility

Falcioni,

The best method that I've found to compress an export file on the fly (due to OS limitations) is the following method:

Subject:  Can one beat the 2 Gigabyte Unix file limit for export files?

Some Unix platforms are still limited to 2 Gigabyte files. This FAQ explains how to
overcome this limitation.

Create a compressed export on the fly. Depending on the type of data, you probably can
export up to 10 gigabytes to a single file.

This example uses gzip. It offers the best compression I know of, but you can substitute
compress, zip, or whatever.

        # create a named pipe
        mknod exp.pipe p
        # read the pipe - output to zip file in the background
        gzip < exp.pipe > scott.exp.gz &
        # feed the pipe
        exp userid=scott/tiger file=exp.pipe ...

That is all there is to it. Contributed by Jared K Still.

Reference

Hope that helps.
Regards,
Peter Gadah

Falcioni Francesco wrote:

> I'm searching for a certified utility  like export that use a
> compression algoritm. Because I'have file size problem on my OS (Oracle
> 7.3.4 on AIX 4.1.5 )
>
> thanks
> f_falcioni_at_aspes.it
> DBA at ASPES Pesaro (Italy)
Received on Tue Apr 20 1999 - 23:40:11 CDT