1、导出
chcp 936 java -jar batch-tool.jar -h 127.0.0.1 -u bas -p basi -P 8306 -D basinfocent_db -o export -t psn_info_sync_fail_rcd_b -s " " -w " 1=1 limit 10 " -np -readsize 1 -quote force -para pause
2、处理一下
导出null的N需要替换掉
导入oracle 文件字符集换成gbk
3、导入
load data append into table psn_info_sync_fail_rcd_b fields terminated by ',' trailing nullcols (psn_info_sync_fail_rcd_id, psn_no, psn_mgtcode, sync_fail_type, sync_type, sync_stas, rid, crte_time date 'yyyy-mm-dd hh24:mi:ss', updt_time date 'yyyy-mm-dd hh24:mi:ss', serv_matt_inst_id, evt_inst_id, crt_opter, opter_admdvs, sys_code)
sqlldr userid= control=hilist_b.ctl log=hilist_blog.log bad=hilist_bbad.csv data=psn_info_sync_fail_rcd_b_0.csv errors=1000 rows=10000 direct=true
