#!/bin/sh
mkdir bz2/$(%Y%m%d)
mkdir -p bz2/$(date -d +${aa}day +%Y%m%d);
for txt in *.txt;
do
echo "$(date "+%Y-%m-%d %H:%M:%S") [$0:$1] $2"
tar -cjf $.tar.bz2 $txt
echo "$(date "+%Y-%m-%d %H:%M:%S") [$0:$1] $2";
done
循环文件,获取文件信息写入oracle
for dat in *20140601*.dat
do
f_size=`wc -c < $dat`
sqlplus -s scott/tiger <<EOF
set feedback off;
set pagesize 0;
update t_mobile_exp_log t
set t.file_size = '$f_size'
where t.file_name = '$dat'
and to_char(t.create_date, 'yyyymmdd') = to_char(sysdate, 'yyyymmdd');
commit;
EOF
echo $dat
echo $f_size
done
exit;