loadlog

来自「oracle常用脚本」· 代码 · 共 18 行

#!/usr/bin/bash

USER_PASSWD=dbuser/oracle

sqlplus -s $USER_PASSWD <<EOF
truncate table charge_fee;
truncate table charge_fee_dtl;
truncate table charge_fee_cfg;
exit
EOF

TABLE=charge_fee
sqlldr $USER_PASSWD control=ctl/${TABLE}.ctl log=ctl/${TABLE}.log direct=true
TABLE=charge_fee_dtl
sqlldr $USER_PASSWD control=ctl/${TABLE}.ctl log=ctl/${TABLE}.log direct=true
TABLE=charge_fee_cfg
sqlldr $USER_PASSWD control=ctl/${TABLE}.ctl log=ctl/${TABLE}.log direct=true