相关代码 |
|
#!/usr/bin/bash USER_PASSWD=dbuser/oracle sqlplus -s $USER_PASSWD 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
相关资源 |
|