Partially Compressed Export File and Mkfifo

From: <A.Bahar_at_billing-components.com>
Date: Fri, 11 Feb 2005 12:02:13 +0100
Message-ID: <CE6EC205C1F2FA40AB48B034F50317794AE7AF@sendling.it.corp.dir>

Hi=20

  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.

Rgds.
Arslan.

more test_exp.sh
#########################################################################=
#######

export EXPORT_DIR=3D/disk7/oradata/test_export cd $EXPORT_DIR
#
# set maximum file size for each chunk of the export file
#

MAXFILESIZE=3D10m
export MAXFILESIZE
#
# create filenames for the parts of the backup... for now let's go to 3
#

FILENAME1=3D$EXPORT_DIR/backup1_$ORACLE_SID.dmp
FILENAME2=3D$EXPORT_DIR/backup2_$ORACLE_SID.dmp
FILENAME3=3D$EXPORT_DIR/backup3_$ORACLE_SID.dmp
FILENAME4=3D$EXPORT_DIR/backup4_$ORACLE_SID.dmp

LOGFILE=3D$EXPORT_DIR/backup_$ORACLE_SID.log
#
# 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
#########################################################################=
#######

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 11 2005 - 06:06:41 CST