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 utility and file size limits

Re: Export utility and file size limits

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Mon, 01 Mar 1999 10:33:03 +0100
Message-ID: <36DA5ECF.60C762A1@DeutschePost.de>


Hi,

compress the export file over a named pipe:

mknod FIFO.dmp p
cat < FIFO.dmp | compress -c > exp.dmp.Z & exp userid/pass file=FIFO.dmp full=y log=...

Compress Ratio is about 25 %, when I worked so. The processes will synchronisyze over the pipe.

Torsten

Kevin Seneviratne wrote:
>
> Hi
>
> Oracle 7.3.4.0.1
> Solaris 2..6
>
> When doing a conventional path export I get the error
>
> EXP-00002: error in writing to export file
>
> the moment the dmp file reaches 2GB.
>
> Any ideas on how do I over come this 2GB limit ?
>
> Thanks
>
> Kevin.
Received on Mon Mar 01 1999 - 03:33:03 CST

Original text of this message

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