一段数据导出使用的shell脚本
/data/develop/exportproj/export.sh

/data/develop/exportproj/insert.sh

filepath=$(tail -1 /data/develop/exportproj/log/insert.log)

filename=${filepath##*FilePath:}

echo $filename
cp $filename /data/develop/exportproj/tmp/contentid.txt

#echo '' > /data/develop/exportproj/log/bangdan_insert.log

sqlldr newweb/newweb@ora10g36 control=/data/develop/exportproj/conf/import_contentid.ctl data=/data/develop/exportproj/tmp/contentid.txt log=/data/develop/exportproj/log/import_contentid.log bad=/data/develop/exportproj/log/import_contentid.bad errors=1000

echo 'insert finished.'