If you've created an export file using the pipe and split technique above, you can import that file like this:
setenv UID sys/change_on_install
setenv FN exp.`date +%j_%Y`.dmp.gz
setenv PIPE /backup/exp_tmp.dmp
setenv ORACLE_SID PROD
# Make a Unix pipe
mknod $PIPE p
# Read the file in the background to the pipe
cat `echo $FN.* | sort` > $PIPE &
# Import from the pipe file as the pipe is being created
imp userid=$UID file=$PIPE full=y commit=y >>& imp_big_table.log
# Remove the pipe
rm –f $PIPE
Get more tips in minutes! Return to the main page.
About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.
IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.