Re: How to export table bigger than filesystem size

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.

-- 
Kirti Deshpande
GTE, DFW Airport      
kirtid658_at_gte.net
=======================================
Please remove all numbers from address 
=======================================