loadlog

一本介绍oracle的书籍

#!/usr/bin/bash

sqlldr dbuser/oracle control=ctl/user_log.ctl log=ctl/user_log.log direct=true
sqlldr dbuser/oracle control=ctl/user_log_partition.ctl log=ctl/user_log_partition.log direct=true
let day=1
while [ $day -le 15 ]
do
    command=$(printf "sqlldr dbuser/oracle control=ctl/user_log_200101%02d.ctl log=ctl/user_log_200101%02d.log direct=true" $day $day)
    eval $command
    let day=day+1
done