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 2GB file size limitation

Re: Export 2GB file size limitation

From: C. Mason <cmason_at_aai.arco.com>
Date: Wed, 8 Apr 1998 19:52:49 GMT
Message-ID: <Er41uo.FCn@news.arco.com>


Try exporting using a pipe with the output going to a compressed file as follows:
(1) create a named pipe

       mknod xx.dmp p
       chmod 775 xx.dmp
(2) direct the export file to the named pipe in background
     cat xx.dmp | compress > xx.dmp &
(3) export to the named pipe
     exp scott/tigger file=xx.dmp

N.K. Lim wrote in message <891953217.387snx_at_yimei.pc.my>...
>I was trying to export an Oracle 7.3.2.3 tablespace on AIX 4.2, but the
>export will fail when the dump file hits 2 GB, even though the OS
>supported >2GB file size. Is there any way to overcome this problem
>without using tape export?
>
>thks and rgds
>-------------------------------------------------------------------
>N.K. Lim limnk_at_yimei.pc.my Penang, Malaysia.
>-------------------------------------------------------------------
Received on Wed Apr 08 1998 - 14:52:49 CDT

Original text of this message

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