在ctrl文件中需要把列名加上，列名的值执行为序列的nextval，数据文件中这个列的值空着就可以

我导入是正常的

# 数据文件
dmdba@k001 [pwd:/tmp]$ cat cs.txt
2 3 4 5 6 7 8 9 20240131 XX 分支机构   

# 控制文件
dmdba@k001 [pwd:/tmp]$ cat cs.ctl
LOAD DATA
INFILE '/tmp/cs.txt'
REPLACE INTO TABLE cs.E5_JGGXB
FIELDS ' ' (
YHJGDM ,
JRXKZH ,
NBJGH ,
YHJGMC ,
SJGLJGDM ,
SJGLNBJGH ,
SJGLJGMC ,
BBZ ,
CJRQ ,
GSFZJG ,
SYNCABLE,
ID "CS.SEQ_FITECH.NEXTVAL",
REPORTID CONSTANT "2")

# 数据导入
dmdba@k001 [pwd:/tmp]$ dmfldr userid=sysdba/SYSDBA:5238 control=\'/tmp/cs.ctl\'  
dmfldr V8
Control file: 

Loaded rows: All

Rows per commit to server: 50000

Rows to skip: 0

Errors count allowed: 100

Whether to load direct: Yes

Whether to insert identity column: No

Whether data is sorted by cluster index: No

Character sets:UTF-8



Data file counts: 1
/tmp/cs.txt

Error file :fldr.bad

Dest table :CS.E5_JGGXB

Column Name                                                                                                                      Packed data type     End
YHJGDM                                                                                                                           CHARACTER            WHT
JRXKZH                                                                                                                           CHARACTER            WHT
NBJGH                                                                                                                            CHARACTER            WHT
YHJGMC                                                                                                                           CHARACTER            WHT
SJGLJGDM                                                                                                                         CHARACTER            WHT
SJGLNBJGH                                                                                                                        CHARACTER            WHT
SJGLJGMC                                                                                                                         CHARACTER            WHT
BBZ                                                                                                                              CHARACTER            WHT
CJRQ                                                                                                                             CHARACTER            WHT
GSFZJG                                                                                                                           CHARACTER            WHT
SYNCABLE                                                                                                                         CHARACTER            WHT
ID                                                                                                                               CHARACTER            WHT
REPORTID                                                                                                                         CHARACTER            WHT

row buffer number is: 16
task thread number is: 16

1 rows committed

Dest table :CS.E5_JGGXB
load success.
1 rows loaded success.
0 rows not loaded due to data error.
0 rows not loaded due to data format error.

Skip logic record counts: 0
Read logic record counts: 1
Refuse logic record counts: 0

3.278(ms) time used.