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: specifying export dmp file size

Re: specifying export dmp file size

From: Uwe Schneider <uwe.schneider_at_xlink.net>
Date: Thu, 29 Jul 1999 16:31:42 +0200
Message-ID: <37A065CE.BFD13AC5@xlink.net>


Hi,

Nathan Phan wrote:
>
> Hi all,
> We have a limitation of 2G file size in AIX, for some valid reason,
> we don't want to enable large file support. How can I do a "full" export
> where the dmp file will be bigger than 2G ? I am looking for something
> like specifying the dump file size like 1.5G and the "exp" will auto
> create another dmp file when it reaches the size and continue to do
> export.

the usual solution for this problem is to create a named pipe and to start a program which reads from the pipe and creates chunks of appropriate size. The export file parameter of exp is just the name of the pipe.

To import the data on the target system you can concatenate the chuncs by a simple "cat" command or you can create a program which writes the files to the pipe.

Uwe
--
uwe.schneider_at_xlink.net Received on Thu Jul 29 1999 - 09:31:42 CDT

Original text of this message

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