dmfldr快速匯出

slnngk發表於2024-03-15

環境:

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.

相關文章