Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: export table > 2G
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