自动导入imp数据

date >> start-date2.log
sqlplus nciclccd_e/nciclccd_e <<EOF
drop table PARTNERINFO;
drop table BKIMP;
drop table BKINFO;
exit
EOF
imp nciclccd_e/nciclccd_e file=par_bk.imp log=par_bk.log full=y ignore=y
date >> end-date2.log

 

 

#! /bin/bash
NLS_LANG="Simplified Chinese_CHINA.ZHS16GBK"
date_time=`date +%Y%m%d_%H`
ORACLE_SID=LCC
ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
export NLS_LANG ORACLE_SID ORACLE_HOME
#date >> start-date2.log
#imp nciclccd_a/nciclccd_a file=scmaster.dmp log=imp_lcc2.log full=y ignore=y
#sqlplus nciclccd_a/nciclccd_a <<EOF
#drop table C_TMP;
#drop table FOBVT_TMP;
#EOF
PATH=$ORACLE_HOME/bin;$PATH
export $PATH
exp nciclccd_a/nciclccd_a file=/home/oracle/ccode.dmp log=/home/oracle/ccode.log  tables = \( CCODE \)
#date >> end-date2.log