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: Segmentation of export output files

Re: Segmentation of export output files

From: Laurent La Fosse <llafosse_at_mediaone.net>
Date: Wed, 12 Aug 1998 06:25:08 -0400
Message-ID: <35D16D84.CDA5290F@mediaone.net>


Hello Sebastian:

We just upgraded from AIX 4.1 to AIX 4.2 which removes the 2 GIG limit on filesize. You could also compress your exports to save space as follows:

#! /bin/ksh
rm /dsk1/usr1.pipe
mknod /dsk1/usr1.pipe p
cat /dsk1/usr1.pipe | compress > /dsk9/usr1.dmp.Z & exp / file=/dks1/usr1.pipe buffer=64000 2>& usr1.log

Good luck,

Laurent

Sebastian Herzog wrote:

> Hi all
> We are running Oracle 7.3 on AIX 4.2.1
> Our Filesystems are definded as Standard JFS which
> are limited to a Filesize of 2GB.
> Now i have the following question ...
> How is it possible to segment the output-file of an large table export.
> Im not sure if i need a large file enabled Filesystem for our "big" exports >2GB.
>
> TIA S.Herzog
Received on Wed Aug 12 1998 - 05:25:08 CDT

Original text of this message

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