Re: Partially Compressed Export File and Mkfifo
- From: Egor Starostin <egorst@xxxxxxxxx>
- To: A.Bahar@xxxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 11 Feb 2005 17:23:13 +0600
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
