项目需求：
将DB2中表单(descartes)数据导入到Oracle中。
实现思路：
1、将DB2数据导出为CSV格式；
2、将CSV格式数据导入到Oracle中。
实现方法：
1、--[DB2导出]--
db2cmd
db2 connect to fgws user db2admin using bitservice
db2 export to c:\temp\descartes.csv of del select * from estate.descartes
2、--[Oracle导入]--
host sqlldr userid=pubr/bitservice@ttonline control=c:\temp\descartes.ctl
3、--[Oracle导出]--
exp system/bitservice@ttonline tables=(pubr.descartes) file=c:\descartes_xy_20111018.dmp log=c:\descartes_xy_20111018.log buffer=655000 compress=y
附录（descartes.ctl）：
load data infile "c:\temp\descartes.csv" into table descartes fields terminated by "," optionally enclosed by '"' trailing nullcols ( de_id , dpid , ipid , ac_id , ac_cat_biz , ac_name_biz , og_id , og_category , og_name , og_idcard , og_idcardno , og_regstatus , ps_id , ps_category , ps_name , ps_idcard , ps_idcardno , ps_nationality , ps_place , ps_buyer_kind , ps_regstatus , hs_id , hs_code , dv_name_province , dv_name_city , dv_code_district , dv_name_district , bd_cat_street , bd_cat_project , bd_code_planning_security_ci , hs_startfloor , hs_endfloor , hs_code_unit , hs_code_planning_security_ci , bd_floors , hs_planning_use , hs_structure , bd_completetime , hs_regstatus , re_category , re_housebookcode , re_housebooktime date "yyyy-mm-dd hh24:mi:ss", re_housecertificatecode , re_cat_house , re_coownershiptype , re_shareproportion , re_houseacquirementtype , re_payment , re_loanmethod , re_housepropertystartdate date "yyyy-mm-dd hh24:mi:ss", re_housepropertyenddate date "yyyy-mm-dd hh24:mi:ss", re_landcertificatecode , re_statelandacquirementtype , re_collectivelandacquirementt , re_parcelpropertytype , re_landpropertystartdate date "yyyy-mm-dd hh24:mi:ss", re_landpropertyenddate date "yyyy-mm-dd hh24:mi:ss", re_regstatus , re_completetime date "yyyy-mm-dd hh24:mi:ss", hs_buildarea , hs_usearea , re_quality )
