HP-UX - Export file Oracle > 2Go

[Gonzalez_1]

Bonjour,

J'ai un PB de limitation de taille de fichiers avec l'utilitaire Export de la version 7.3.4 d'Oracle, le support Oracle m'a envoyT cette procTdure :

Est-ce que quelqu'un l'a dTja utilisT ?
Existe-t-il une autre solution ?

Merci

===================================================================
#!/usr/sh
#
# SCCS Status : 1.2
# Author : Johan Verbrugghen (jverbrug@behux2.be.oracle.com)
# Created On : 96/10/28 00:02:20
# Last updated : 96/11/06 22:33:52
#
# @(#) (1.2) /home/jverbrug/src/SCCS/s.crea_exp.sh
#
# $Header: Export data through pipes over multiple filesystems (break 2
Gig) $
#

DIR1=./export.p1.Z # point to export-file1 on filesystem disk1
DIR2=./export.p2.Z # point to export-file2 on filesystem disk2
DIR3=./export.p3.Z # point to export-file3 on filesystem disk3
MAXFILESIZE=2950m # max size of exportfile part on one filesystem
#
SYSTEMPASSWD=system/manager

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 full=y buffer=1000000 file=wrkpipe

# clean up the stuff
rm exportpipeaa exportpipeab exportpipeac wrkpipe


#!/usr/sh
#
# SCCS Status : 1.2
# Author : Johan Verbrugghen (jverbrug@behux2.be.oracle.com)
# Created On : 96/10/28 00:02:20
# Last updated : 96/11/06 22:37:57
#
# @(#) (1.2) /home/jverbrug/src/SCCS/s.crea_imp.sh
#
# $Header: Import data coming from file spread over multiple filesystems

$
#

DIR1=./export.p1.Z # point to export-file1 on filesystem disk1
DIR2=./export.p2.Z # point to export-file2 on filesystem disk2
DIR3=./export.p3.Z # point to export-file3 on filesystem disk3
#
SYSTEMPASSWD=system/manager

# create wrkpipe to import from
mkfifo wrkpipe

# start reader from wrkpipe to import the export
imp $SYSTEMPASSWD full=y buffer=1000000 commit=y file=wrkpipe &

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

# clean up the stuff
rm wrkpipe

===========================================================

[Mike McKinlay]

For the French-impaired, the http://babelfish.altavista.com/ translation ...

Hello,

I have PB of limitation of size of files with the Export utility of version 7.3.4 of Oracle, the Oracle support has me envoyT this procTdure:

Somebody A dTja utilisT?
Does there exist another solution?

Thank you

[Gonzalez_1]

Thank you for the software.

[CHRIS_ANORUO]

Shown in question #Export data through pipes over multiple filesystems (break 2
Gig).

That is where the limitations is from. Look for an updated software to do more than 2Gb for you.

[Brian M. Fisher · Accepted solution]

"Oracle utilities, including the exp export utility, cannot
handle files larger than 2 GB.

You can handle this limitation in the following manner:

- Make sure the file system is set up correctly
(large file support enabled).

- Use pipes to assist Oracle's export with files larger than
2 GB.

Please read Oracle Note 30528.1, which explains the use of Named Pipes
to circumvent the 2 GB issues with utilities such as exp." from HP document #1100292698

I know this process works, although I do not know the exact syntax.

Brian
<*(((>< er

[Gonzalez_1]

It's OK with this version : MAXFILESIZE=2000m

Thank's a lot

===================================================================
#!/usr/sh
#
# SCCS Status : 1.2
# Author : Johan Verbrugghen (jverbrug@behux2.be.oracle.com)
# Created On : 96/10/28 00:02:20
# Last updated : 96/11/06 22:33:52
#
# @(#) (1.2) /home/jverbrug/src/SCCS/s.crea_exp.sh
#
# $Header: Export data through pipes over multiple filesystems (break 2 Gig) $
#
set -x
DIR1=/r/oracle/save4/export.p1 # point to export-file1 on filesystem disk1
DIR2=/r/oracle/save2/export.p2 # point to export-file2 on filesystem disk2
DIR3=/r/oracle/save3/export.p3 # point to export-file3 on filesystem disk3
MAXFILESIZE=2000m # max size of exportfile part on one filesystem
#
SYSTEMPASSWD=XXXXXX/XXXX

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 | split -b $MAXFILESIZE - exportpipe &

# start the real export now into the workpipe (wrkpipe)
exp $SYSTEMPASSWD owner=pergwner buffer=1000000 file=wrkpipe log=rdcowner.log

# clean up the stuff
#rm exportpipeaa exportpipeab exportpipeac wrkpipe