Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to export table bigger than filesystem size

Re: How to export table bigger than filesystem size

From: Johannes Blankenstein <jbla_at_giraffe.snafu.de>
Date: 1998/01/05
Message-ID: <EMBxGq.Jxu@giraffe.snafu.de>#1/1

In article <68q3o9$om_at_hdxl16.telecom.ptt.nl>,

        g.r.s.deisz_at_ptt-telecom.unisource.nl (g.r.s. deisz) writes:

> In article <01bd1797$bb6c9d40$37dda487_at_ramanan.att.com>,
>    "RR" <ramanan_at_att.com> wrote:

>>Anyone,
>>
>>A simple question. What is the easiest way to export a table which is
>>bigger than the largest filesystem size. For example I have tables which
>>are bigger than 2GB and my machine does not support filesystems greater
>>than 2GB.
>>
>>RR
> 
> You can either export to tape or compress your export file. On Unix 
> compressing can be done by creating a pipe, start a compress process that 
> reads from the pipe and writes to a file and finally export to the pipe.

If you have access to an SAP/R3 CD you can use R3CHOP. This utility allows to compress the export file and also allows to splitt the export file into several files on different filesystems.

        Hannes

-- 
Johannes Blankenstein; Berlin; Germany
Email:   jbla_at_giraffe.snafu.de
         jbla_at_giraffe.in-berlin.de
Received on Mon Jan 05 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US