你好，请参考下：

--创建表
create table t(id int,name varchar2(100));
insert into t values(1,'1'),(2,'ab'),(3,'b');
commit;
exit;

#导出
tee /tmp/gather.ctl <<-"EOF"
OPTIONS
(
ROWS=100000
INDEX_OPTION=2
)
load
infile '/tmp/gather.txt' STR  '|'
REPLACE
into table "SYSDBA"."T"
fields '|'
EOF

$DM_HOME/bin/dmfldr USERID=SYSDBA/SYSDBA  CONTROL=\'/tmp/gather.ctl\' mode=\'out\'

改成这种方法试一下
LOAD DATA
INFILE ‘/data/backup/xxxxx.txt’
INTO TABLE XXX.XXXX FIELDS ‘|’