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: <A.Bahar_at_billing-components.com>
Date: Fri, 11 Feb 2005 14:35:47 +0100
Message-ID: <CE6EC205C1F2FA40AB48B034F50317794AE7B3@sendling.it.corp.dir>


thanks

-----Original Message-----
From: Egor Starostin [mailto:egorst_at_gmail.com] Sent: Friday, February 11, 2005 12:23 PM To: Bahar, Arslan
Cc: oracle-l_at_freelists.org
Subject: Re: Partially Compressed Export File and Mkfifo

> I have some parititoned export files which were produced with =3D
> 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=3D3Dexportpipeaa of=3D3D$FILENAME1 &
> dd if=3D3Dexportpipeab of=3D3D$FILENAME2 &
> dd if=3D3Dexportpipeac of=3D3D$FILENAME3 &
> dd if=3D3Dexportpipead of=3D3D$FILENAME4 &
> #
> # start the reader from the wrkpipe to compress and split the export
> #
> dd if=3D3Dwrkpipe|compress|split -b $MAXFILESIZE - exportpipe &
> #
> # start the export for real
> #
> exp system/manager file=3D3Dwrkpipe tables=3D3Dsystem.test_table =3D
> direct=3D3Dyes LOG=3D3D$LOGFILE

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

--=20
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 11 2005 - 08:40:12 CST

Original text of this message

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