Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partially Compressed Export File and Mkfifo

Re: Partially Compressed Export File and Mkfifo

From: Egor Starostin <egorst_at_gmail.com>
Date: Fri, 11 Feb 2005 17:23:13 +0600
Message-ID: <f0fc91970502110323bd74eb6@mail.gmail.com>


> I have some parititoned export files which were produced with =
> following script.
> I have tried to write a import script but I could not success.
> Plese someone can tell me how can I import these files.
> #
> # create the pipes
> #
> mkfifo exportpipeaa
> mkfifo exportpipeab
> mkfifo exportpipeac
> mkfifo exportpipead
> mkfifo wrkpipe
> umask 000
> #
> # start the readers from the pipes to create the export files
> #
> dd if=3Dexportpipeaa of=3D$FILENAME1 &
> dd if=3Dexportpipeab of=3D$FILENAME2 &
> dd if=3Dexportpipeac of=3D$FILENAME3 &
> dd if=3Dexportpipead of=3D$FILENAME4 &
> #
> # start the reader from the wrkpipe to compress and split the export
> #
> dd if=3Dwrkpipe|compress|split -b $MAXFILESIZE - exportpipe &
> #
> # start the export for real
> #
> exp system/manager file=3Dwrkpipe tables=3Dsystem.test_table =
> direct=3Dyes LOG=3D$LOGFILE

mkfifo impipe
cat $FILENAME1 $FILENAME2 $FILENAME3 $FILENAME4 |uncompress > impipe & imp system/manager file=impipe tables=...

-- 
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 11 2005 - 06:25:58 CST

Original text of this message

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