表WF_CASE_RUN里面含有大字段，通过DTS迁移效率低下。可以通过dmfldr快速装载完成数据的迁移工作。
新建控制文件vim test2lob.ctrl
内容如下：
LOAD DATA
INFILE ‘’
INTO TABLE WF_CASE_RUN
FIELDS ‘|’
(
ID,
CASENAME,
STARTUSER,
LASTPERFORMER,
STATE,
SUBPROCESS,
STARTSUBPROCESSNUM,
PROCESSINDEX,
PROCESSNAME,
PROCESSID,
STARTDATE,
UPDATEDATE,
CASEOBJECT,
CASE_CONTENT
)
快速导出数据到指定目录下：
./dmfldr userid=OAXCDB/Seeyon123@..0.241:5236 control=‘/dm8/dmfldr/test2lob.ctrl’ data=‘/dm8/dmfldr/test2lob.txt’ mode=‘out’ lob_directory=‘/dm8/dmfldr’ lob_file_name=‘test2lob.lob’
快速把指定目录下数据导入到指定库里面：
./dmfldr userid=OAXCDB/Seeyon123@.*.3.1:5236 control=’/dm8/dmfldr/test2lob.ctrl’ data=‘/dm8/dmfldr/test2lob.txt’ mode=‘in’ lob_file_name=‘test2lob.lob’ client_lob=true lob_directory=‘/dm8/dmfldr’ direct=true set_identity=false;