oracle定时导dmp数据

#!/bin/sh
/home/oracle/.bash_profile
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1
export ORACLE_SID=cis


myFile="/home/oracle/KHTS/ok.log"
balInfo="/home/oracle/KHTS/ZJ_CUST_BAL_INFO.dmp"


myLog="/home/oracle/KHTS/ok.log"
echo "导入开始！" echo `date`
if [ -f "$myFile" ]; then
        /opt/app/oracle/product/11.2.0/db_1/bin/sqlplus -s dbrw_cis/dbrw_cis <<EOF
        drop TABLE zj_cust_bal_info;
        drop TABLE ZJ_ACC_CARD;
        drop table ZJ_INST_INFO;
        drop table ZJ_CUST_CONN_INFO;
        drop table ZJ_CUST_VIP;
EOF
        /opt/app/oracle/product/11.2.0/db_1/bin/imp userid=system/zjxxjSunrise815@CIS4.26 fromuser=CPDDS_PDATA touser=dbrw_cis  ignore=y file=/home/oracle/KHTS/ZJ_CUST_BAL_INFO.dmp buffer=409600000 commit=y log=/home/oracle/KHTS/ZJ_CUST_BAL_INFO.log  feedback=10000
        /opt/app/oracle/product/11.2.0/db_1/bin/imp userid=system/zjxxjSunrise815@CIS4.26 fromuser=CPDDS_PDATA touser=dbrw_cis ignore=y file=/home/oracle/KHTS/ZJ_ACC_CARD.dmp buffer=409600000 commit=y log=/home/oracle/KHTS/ZJ_ACC_CARD.log  feedback=10000
        /opt/app/oracle/product/11.2.0/db_1/bin/imp userid=system/zjxxjSunrise815@CIS4.26 fromuser=cpdds_Pdata touser=dbrw_cis  ignore=y file=/home/oracle/KHTS/ZJ_INST_INFO.dmp buffer=409600000 commit=y log=/home/oracle/KHTS/ZJ_INST_INFO.log  feedback=10000
        /opt/app/oracle/product/11.2.0/db_1/bin/imp userid=system/zjxxjSunrise815@CIS4.26 fromuser=cpdds_Pdata touser=dbrw_cis file=/home/oracle/KHTS/ZJ_CUST_CONN_INFO.dmp buffer=409600000 commit=y log=/home/oracle/KHTS/ZJ_CUST_CONN_INFO.log  feedback=10000
        /opt/app/oracle/product/11.2.0/db_1/bin/imp userid=system/zjxxjSunrise815@CIS4.26 fromuser=cpdds_Pdata touser=dbrw_cis file=/home/oracle/KHTS/ZJ_CUST_VIP.dmp buffer=409600000 commit=y log=/home/oracle/KHTS/ZJ_CUST_VIP.log  feedback=10000
         echo "导入完成！" echo `date`
         rm -rf "$myFile"
         mv -u /home/oracle/KHTS/ZJ_CUST_BAL_INFO.dmp /home/oracle/KHTS/ZJ_ACC_CARD.dmp /home/oracle/KHTS/ZJ_CUST_CONN_INFO.dmp /home/oracle/KHTS/ZJ_CUST_VIP.dmp /home/oracle/KHTS/ZJ_INST_INFO.dmp /home/oracle/backup/


else
         echo "failer"
fi