从oracle迁移数据到mysql(客服邮箱具体例子)

#####oracle parameter #####
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/10.2/db
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib
export PATH=$ORA_CRS_HOME/bin:/sbin:$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/OPatch/
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib/
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export LANG=en_US
##




/home/oracle/10.2/db/bin/sqlplus -S /nolog < conn networkmonit/******@tsqos
set feedback off
set heading off
set linesize 1000
set arraysize 5000
set pagesize 0
set trimspool on
set termout off
set colsep ","
spool /home/mysql/scripts/oracle_to_mysql/result/t_10086mailfolder_tmp.txt;
Select 
 to_char(CREATETIME,'yyyy-mm-dd hh24:mi:ss') ||','||
 TO_MSG                                      ||','||
 PROV                                        ||','||
 FILTERMSG                                   ||','||
 NOFILTERMSG                                 ||','||
 PCT
from antispam.v_mv_10086mailfoldernow_stat where CREATETIME>=trunc(sysdate-1) and CREATETIME spool off
eof




export PATH=/mysql/product/bin:/mysql/product/libexec:$PATH:$HOME/bin
export LANG=zh_CN.utf8
/mysql/product/bin/mysql -uroot -p****** kfyx -Bse "load data infile '/home/mysql/scripts/oracle_to_mysql/result/t_10086mailfolder_tmp.txt'   into table t_10086mailfolder   character set gbk FIELDS TERMINATED BY ',' lines terminated by '\n'  (createtime,account,prov,filtermsg,nofiltermsg,pct); "

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29114615/viewspace-1407510/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29114615/viewspace-1407510/