RE: Partially Compressed Export File and Mkfifo
- From: <A.Bahar@xxxxxxxxxxxxxxxxxxxxxx>
- To: <egorst@xxxxxxxxx>
- Date: Fri, 11 Feb 2005 14:35:47 +0100
thanks
-----Original Message-----
From: Egor Starostin [mailto:egorst@xxxxxxxxx]
Sent: Friday, February 11, 2005 12:23 PM
To: Bahar, Arslan
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: