linux文件入库脚本

linux文件入库脚本

 

----linux文件入库脚本 

#!/bin/bash 

#一个输入参数时间，格式为yyyymmdd,不输入时，使用系统前一天日 

 

if [ ${#1} -eq 6 ] ; then 

day=$1 

else 

day=$(date -d "" +%Y%m) 

fi 

 

if [ ${#1} -eq 6 ] ; then 

day1=$2 

else 

day1=$(date -d "1 month ago" +%Y%m) 

fi 

source /home/oracle/.bash_profile 

 

file_name=/oradata/org_data/ftp_down/itv/login/itv_login.ctl 

 

echo "LOAD DATA">$file_name 

ls /oradata/org_data/ftp_down/itv/login/ |grep "$day" | while read -a line 

do 

echo "INFILE  \"/oradata/org_data/ftp_down/itv/login/${line[0]}\" \"str'\\r\\n'\"">>$file_name 

done 

echo "INTO TABLE ITV_LOGIN_M">>$file_name 

echo "APPEND">>$file_name 

echo "FIELDS TERMINATED BY '|'">>$file_name 

echo "TRAILING NULLCOLS ">>$file_name 

echo "( ">>$file_name 

echo "WIDTHID,">>$file_name 

echo "USERID,">>$file_name 

echo "CREATEDATE,">>$file_name 

echo "LOGINTIMES,">>$file_name 

echo "VIEWMINUTS,">>$file_name 

echo "LEIXING,">>$file_name 

echo "MONTH CONSTANT "$day1"">>$file_name 

echo ")">>$file_name 

 

sqlldr  userid=username/passwd control=$file_name log=/oradata/org_data/ftp_down/itv/login/log/itvlogin_$day.log errors=600000000 direct=Y