数据格式如下:
aaa|bbb|ccc|ddd|23控制文件如下:
options (rows=10000, bindsize=10000000)
load data
infile 'filepath'
badfile 'filepath' into table t_zakk
append fields terminated by '|'
trailing nullcols (a, b, c, d, num terminated by whitespace)报错如下:
ora-26026: ????? jfzl.pk_t_ap_zakk_passrec ???????????
sql *loader-2026: the load was aborted because sql loader cannot continue.请高手指点迷津,不胜感谢!
aaa|bbb|ccc|ddd|23控制文件如下:
options (rows=10000, bindsize=10000000)
load data
infile 'filepath'
badfile 'filepath' into table t_zakk
append fields terminated by '|'
trailing nullcols (a, b, c, d, num terminated by whitespace)报错如下:
ora-26026: ????? jfzl.pk_t_ap_zakk_passrec ???????????
sql *loader-2026: the load was aborted because sql loader cannot continue.请高手指点迷津,不胜感谢!
infile 'filepath'
badfile 'filepath'
append
into table t_zakk
trailing nullcols
(a char terminated by '|',
b char terminated by '|',
c char terminated by '|',
d integer(2) terminated by whitespace)
试一下
未经测试