cd $HOME/data/
ls yilta.txt > ${HOME}/data/datalist.log
num=`cat ${HOME}/data/data.log | wc -l`num2=1
if [ $num != $num2 ]
then
echo "$currdate|ftp失败" >> ${HOME}/data/msg.log
else
echo "$currdate|ftp成功" >>${HOME}/data/msg.log
fi
sqlldr userid=${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} control=${HOME}/data/main.ctl log=${HOME}/data/main.log direct=true
numyilta10=`cat ${HOME}/data/yilta.txt | wc -l`
sqlplus ${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} <<!
ALTER TABLE yilta nologging;sqlldr userid=${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} control=${HOME}/data/yilta.ctl log=${HOME}/data/yilta .log direct=true
echo "$currdate|成功|yilta |$numyilta 10" >>${HOME}/data/err.log
ls yilta.txt > ${HOME}/data/datalist.log
num=`cat ${HOME}/data/data.log | wc -l`num2=1
if [ $num != $num2 ]
then
echo "$currdate|ftp失败" >> ${HOME}/data/msg.log
else
echo "$currdate|ftp成功" >>${HOME}/data/msg.log
fi
sqlldr userid=${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} control=${HOME}/data/main.ctl log=${HOME}/data/main.log direct=true
numyilta10=`cat ${HOME}/data/yilta.txt | wc -l`
sqlplus ${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} <<!
ALTER TABLE yilta nologging;sqlldr userid=${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} control=${HOME}/data/yilta.ctl log=${HOME}/data/yilta .log direct=true
echo "$currdate|成功|yilta |$numyilta 10" >>${HOME}/data/err.log
解决方案 »
- 问一个关于physical design的问题。非常感谢
- 哥怒了,破PLSQL用的我蛋疼菊紧 求助!
- SQLNET.ORA的文件格式是什么样的?
- 我该怎么写这条语句?
- 这样写过程有问题吗?
- oracle数据库中一张表的字段只能有一个是text类型吗?
- 用MS SQLSERVER DTS 将数据导入ORACLE中为何先要将表名改为大写?
- 菜鸟问一个关于包的问题
- 怎么做到,只在数据库中保存最近一个月的数据,自动覆盖旧数据?
- oracle中如何将某个字段中内容带有分隔符字符都加一个固定前缀值
- 初学者 麻烦求助一个SQL语句 显示 ORA-00936: missing expression
- oracle92中如何创建类型,类型和物理表的结果一样
--进入目录 $HOME 是环境变量,查看 echo $HOME
cd $HOME/data/
--查看 yilta.txt 信息,将查看结果写入 datalist.log 文件,感觉少个 >
ls yilta.txt > ${HOME}/data/datalist.log
--查看 data.log 记录行数(wc -l),将这个值赋给 num
num=`cat ${HOME}/data/data.log | wc -l`num2=1
if [ $num != $num2 ]
then
--打印 日期|ftp失败 到 msg.log 文件
echo "$currdate|ftp失败" >> ${HOME}/data/msg.log
else
echo "$currdate|ftp成功" >>${HOME}/data/msg.log
fi--sqlldr 命令 不用解释了吧
sqlldr userid=${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} control=${HOME}/data/main.ctl log=${HOME}/data/main.log direct=true--看yilta.txt 记录行数
numyilta10=`cat ${HOME}/data/yilta.txt | wc -l`--进入oraclesqllus环境
sqlplus ${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} <<!--执行如下命令 后回到宿主环境 (<<!)
ALTER TABLE yilta nologging;--执行sqlldr
sqlldr userid=${ORACLE_USER}/${ORACLE_PWD}@${ORACLE_SID} control=${HOME}/data/yilta.ctl log=${HOME}/data/yilta .log direct=true
--打印日志
echo "$currdate|成功|yilta |$numyilta 10" >>${HOME}/data/err.log