Re: 2G Max on export file

From: Martin Gouge <martin.gouge_at_capitale.qc.ca>
Date: Tue, 6 Apr 1999 14:10:18 -0400
Message-ID: <7ediou$4hc$1@news.quebectel.com>

## Compressed database export of a very LARGE database
## ie: "compressed" dump file cannot fit on a single disk
## partition.

#! /bin/sh

/bin/rm /dsk1/exp.pipe
/bin/rm /dsk1/disk.pipeaa /dsk1/disk.pipeab /dsk1/disk.pipeac

/bin/mknod /dsk1/exp.pipe p
/bin/mknod /dsk1/disk.pipeaa p
/bin/mknod /dsk1/disk.pipeab p
/bin/mknod /dsk1/disk.pipeac p

cat /dsk9/exp.pipe | compress | spilt -b 2000 /dsk1/disk.pipe &
cat /dsk1/disk.pipeaa > /dsk1/exp_aa.dmp.Z &

cat /dsk1/disk.pipeab > /dsk2/exp_ab.dmp.Z & cat /dsk1/disk.pipeac > /dsk3/exp_ac.dmp.Z &

exp / file=/dsk9/exp.pipe buffer=1024000 2>& exp.log

Martin

<gcb45_at_dial.pipex.com> a écrit dans le message : 370a3266.14136974_at_news.dial.pipex.com...
> I know that there is a 2G ceiling on UNIX files. One of my database
> export files is approaching the 2G limit and it is already compressed
> on the fly.
> Does anyone have any suggestions as to what should be done to deal
> with this problem?
>
> Any help would be appreciated
> Thanks
> Gary
Received on Tue Apr 06 1999 - 13:10:18 CDT