loadlog

一本介绍oracle的书籍

#!/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