#!/bin/sh
file_list=`ls -l | awk '{print $9}' | sed 's/\.dbf//'`
t=1
for i in $file_list
do
if [ "$t" -lt "10" ];then
mv $i'.dbf' $i'00'$t'.dbf'
elif [ "$t" -ge "10" ] && [ "$t" -lt "100" ];then
mv $i'.dbf' $i'0'$t'.dbf'
else
mv $i'.dbf' $i$t'.dbf'
fi
t=`expr $t + 1`
done
#!/usr/bin/ksh
rm -rf sql.txt
sqlplus TRANSDATA/TIME_2020<< EOF
spool sql.txt
select status from v$instance;
spool off
exit;
EOF