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: Help with Import / Export

Re: Help with Import / Export

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Aug 2002 23:32:41 +0200
Message-ID: <nvillustk72qk5l87e1gjcnrl0nvp5svch@4ax.com>


On 14 Aug 2002 13:22:47 -0700, amerar_at_iwc.net (Arthur) wrote:

>Hi All,
>
>I need some help with this import problem. We exported our entire
>database using the following script:
>
>DIR1=$EXPORT_PATH/$ORACLE_SID/$ORACLE_SID.p1.Z
>DIR2=$EXPORT_PATH/$ORACLE_SID/$ORACLE_SID.p2.Z
>MAXFILESIZE=2000m
>
>mkfifo exportpipeaa
>mkfifo exportpipeab
>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 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 buffer=1000000 file=wrkpipe direct=y
>log=$BACKUP_PATH/$ORACLE_SID/exp.log full=y
># clean up the stuff
>rm exportpipeaa exportpipeab wrkpipe
>
>
>This creates a file of 1.5GB. I need to import a table from this
>export file. I cannot uncompress it because it is too big for any one
>filesystem we have. So, I tried the import script:
>
>
>DIR1=/tmp/DR_CASHT.p1.Z
>mkfifo wrkpipe
>umask 000
>
>imp $SYSTEMPASSWD buffer=4096000 commit=y ignore=y file=wrkpipe
>tables=audit_trail log=/tmp/imp.log &
>
>cat $DIR1 | uncompress | dd of=wrkpipe
>
>
>What happens is I get a segmentation fault and a core dump.
>
>I really need to get at this data for a certain table. Can anyone
>offer any suggestions? Or maybe a Perl script to go through the
>export file?
>
>Thanks,
>
>Arthur

On 8i you can use the FILESIZE= and FILE= parameter to export into multiple files.
In your script it appears to me you should swap the cat and imp lines

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 14 2002 - 16:32:41 CDT

Original text of this message

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