一段数据导出使用的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.'
