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: export table > 2G

Re: export table > 2G

From: <jdarrah_co_at_my-deja.com>
Date: Fri, 09 Feb 2001 17:22:37 GMT
Message-ID: <96190g$8du$1@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 - 11:22:37 CST

Original text of this message

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