自动sqlldr脚本

auto_sqlldr.sh

oracleFilePath="/oradata/dypt/arch1/userModelFile/"
oracleHome="/app/oracle/product/10204/db_1/bin/sqlldr"
userID=user/pwd@ip:port:sid
export ORACLE_SID=YDPT1
export ORACLE_HOME=/app/oracle/product/10204/db_1
export PATH=.:$ORACLE_HOME/bin:$PATH:.
date=`date '+%Y%m%d'`
echo $date
cd $oracleFilePath
txtFileName=`find . -name "$date*".txt`
ctlFileName=`find . -name "$date*".ctl`
logFileName=`find . -name "$date*".log`
if [ "$logFileName" = "" ]; then
if [ "$txtFileName" = "" ]; then
echo "txtFileName is null"
elif [ "$ctlFileName" = "" ]; then
echo "ctlFileName is null"
elif [ "$txtFileName" != "" -a "$ctlFileName" != "" ]; then
notPathTXTFileName=${txtFileName##*/}
echo "notPathTXTFileName:$notPathTXTFileName"
notPathCTLFileName=${ctlFileName##*/}
echo "notPathCTLFileName:$notPathCTLFileName"
controlPath="$oracleFilePath$notPathCTLFileName"
logPath="$oracleFilePath$date.log"
sqlldrCMD="$oracleHome userid=$userID control=$controlPath log=$logPath errors=4000000 readsize=2000000 rows=1000 bindsize=2000000"
echo $sqlldrCMD
exec $sqlldrCMD
fi
else
echo "sqlldr $date.log Has been implemented"
fi

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22918188/viewspace-1046016/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22918188/viewspace-1046016/