cancel
Showing results for 
Search instead for 
Did you mean: 

HP-UX - Export file Oracle > 2Go

SOLVED
Go to solution
Gonzalez_1
Occasional Visitor

HP-UX - Export file Oracle > 2Go

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

===========================================================
5 REPLIES
Mike McKinlay
Honored Contributor

Re: HP-UX - Export file Oracle > 2Go

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

"Hope springs eternal."
Gonzalez_1
Occasional Visitor

Re: HP-UX - Export file Oracle > 2Go

Thank you for the software.
CHRIS ANORUO
Honored Contributor

Re: HP-UX - Export file Oracle > 2Go

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.

When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Brian M. Fisher
Honored Contributor
Solution

Re: HP-UX - Export file Oracle > 2Go

"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
Perception IS Reality
Gonzalez_1
Occasional Visitor

Re: HP-UX - Export file Oracle > 2Go

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