Re: export table > 2G

In fact it is even easier to:

$ exp ... file=stdout ... | gzip > expfile.dmp.gz

Unfortunately this does not work for import (ie. using file=stdin), so in that case you will need the named pipe.

HTH,
Gollum

<jdarrah_co_at_my-deja.com> wrote in message news:96190g$8du$1_at_nnrp1.deja.com...
> If your using 8i you can export to multiple files. otherwise on unix
> export the file to a pipe then gzip -c from the pipe to a file
>
> $ mknod exppipe.dmp p
> $ exp file=expipe.dmp
> from another shell
> $ gzip -c expipe.dmp > expfile.dmp.gz
>
> This should work as long as the table is under around 14G
>
> In article <961854$7d1$1_at_nnrp1.deja.com>,
> rkatofiasc_at_classifiedventures.com wrote:
> > I need to export a table that is over 2G. How can I get around
 oracle's
> > limitation?
> >
> > Thanks Rob
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 09 2001 - 13:20:42 CST