Re: How to export table bigger than filesystem size

This script will work on most UNIX systems:

Note that you need to have gzip on your system or some other utility that will compress stdin.

• Beging Text ------ #!/usr/bin/ksh mknod /tmp/oracle_pipe p exp userid=system/password file=/tmp/oracle_pipe inctype=complete grants=y compress=n 2>&1 & cat /tmp/oracle_pipe | gzip -c > /backup/export/exp.dmp.gz rm /tmp/oracle_pipe
• End Text

If you have any questions please feel free.

said_at_wwisp.com

RR wrote in message <01bd1797$bb6c9d40$37dda487_at_ramanan.att.com>...
>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
Received on Fri Jan 02 1998 - 00:00:00 CST