Re: exp file bigger than 2 GB on 7.0 oracle??

From: Søren Lauritzen <sorenl_at_rki.dk>
Date: Wed, 27 Oct 1999 12:43:59 +0200
Message-ID: <J2GR3.715$xN.3695449134@news.euroconnect.net>

Maybe it is a OS limit, you can can use this work-around:

Export:

DIR1=/data01/nfs/rki3.p1.Z   # point to export-file1 on filesystem disk1
DIR2=/data01/nfs/rki3.p2.Z   # point to export-file2 on filesystem disk2
DIR3=/data01/nfs/rki3.p3.Z   # point to export-file3 on filesystem disk3
MAXFILESIZE=900m     # max size of exportfile part on one filesystem

#
SYSTEMPASSWD=id/pw

mkfifo exportpipeaa
mkfifo exportpipeab
mkfifo exportpipeac
mkfifo wrkpipe

# start reader from first pipe to create export-file1 dd if=exportpipeaa of=$DIR1 &
# start reader from second pipe to create export-file2 dd if=exportpipeab of=$DIR2 &

# start reader from third pipe to create export-file3 dd if=exportpipeac of=$DIR3 &

# start reader from wrkpipe to compress the export stream and split into # into three pieces of size = MAXFILESIZE (max) dd if=wrkpipe | compress | split -b $MAXFILESIZE - exportpipe &

# start the real export now into the workpipe (wrkpipe) exp $SYSTEMPASSWD owner=rki3 buffer=1000000 file=wrkpipe COMPRESS=N

# clean up the stuff
rm exportpipeaa exportpipeab exportpipeac wrkpipe

import:

DIR1=/work/fido/rki3.p1.Z   # point to export-file1 on filesystem disk1
DIR2=/work/fido/rki3.p2.Z   # point to export-file2 on filesystem disk2
DIR3=/work/fido/rki3.p3.Z   # point to export-file3 on filesystem disk3

#
SYSTEMPASSWD=id/pw

# create wrkpipe to import from
mkfifo wrkpipe

# start reader from wrkpipe to import the export imp $SYSTEMPASSWD full=y buffer=1000000 commit=y ignore=n indexes=y log=rki3_dta
.log file=wrkpipe &

# create import stream coming from three export-files cat $DIR1 $DIR2 $DIR3 | uncompress | dd of=wrkpipe

# clean up the stuff
rm wrkpipe

/Søren
Gregor Loock <Gregor.Loock_at_ivz.de> wrote in message news:7u42j1$1p0$1_at_news.sfb.de...
> hello ,
>
> I try to make a database export with the exp command everything works
great
> till the file is 2GB than the exp breaks up with cant write ....
>
> first the problem was the Solaris 2.6 it is solved now
> I mounted a filesystem with option largefiles and can make a mkfile -v
> 5000m filename and it works !
>
> the exp still breaks up after 2 GB size
>
> what can i do now ?
>
> thanx
> Gregor
>
>
Received on Wed Oct 27 1999 - 05:43:59 CDT