Re: How to export table bigger than filesystem size

If the compressed dump file gets more than 2GB, you can "split" instead of "compress" the exported file using the same method.

David

On Fri, 02 Jan 1998 11:03:47 -0600, Kirti Deshpande <kirtid658_at_gte.net> wrote:

>RR 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
>
>RR:
> I am assuming your platform is UNIX.
> You can try using compression while exporting the table. Hopefully, the
>compressed dump file would be less than 2GB.
> Here is how to do it:
> Create a UNIX pipe:
> mknod exp.pipe p
> Run compress using this pipe in background :
> compress < exp.pipe > table.dmp &
> Export the table to the pipe file :
> exp user/passwd file=exp.pipe tables=t1 ......
> You can use buffer= and other export parameters as usual.
> Importing the table would be similar except you will use 'uncompress'
>command. Make sure the output of uncompress is sent to the standard
>output which is re-redirected to the pipe file.
> If the compressed dump file gets more than 2GB, then you will have to
>use UNIX tricks to get the job done or export to tapes.
> E-mail me if you need more info on these.
Received on Sun Jan 04 1998 - 00:00:00 CST