dmfldr快速导出

环境:

Os:Centos 7

DB:V8

 

1.准备控制文件

OPTIONS
(
ROWS=100000
INDEX_OPTION=2
)
load
infile '/tmp/tb_test.txt'
str X '0A'
REPLACE
into table "hxl"."tb_test"
fields '|'
(
"id",
"name"
)

 

执行导出命令

[dmdba@host01 ~]$ dmfldr userid=sysdba/dameng123 control=\'/home/dmdba/f.ctl\' mode=\'OUT\'
dmfldr V8
5 rows is load out
export success.
5 rows exported success. 
155860.678(ms) time used.

 

发现导出很慢，若将INDEX_OPTION参数去掉会很快

[dmdba@host01 ~]$ dmfldr userid=sysdba/dameng123 control=\'/home/dmdba/f.ctl\' mode=\'OUT\'
dmfldr V8
5 rows is load out
export success.
5 rows exported success. 
9.012(ms) time used.