Question

请求各位oracle 大神解决一下sqlldr 数据报错问题

load data infile 'weic_test.dat' append into table TS_FWJD_KD_INSTALL_DAY ( TIMEST, ACCOUNT_ID, RECYCLE_DATE, EPARCHY_CODE, CUST_NAME, CUST_PHONE, CUST_ADDRESS, CUST_LAN_WIDTH, INSTALL_DATE, IS_NAME, IS_PHONE, IS_ADDRESS, IS_ONTIME, USER_SCORE, ONTIME_SCORE, SERVICE_SCORE, EQUIP_SCORE, WEAR_SCORE, TEST_SCORE, OTHER_SCORE, USER_ADVICE, IS_DISTINCT ) fields terminated by ',' optionally enclosed by '"' trailing nullcols 以上是控制文件数据文件内容为 test.dat 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22 sqlldr userid=user/passwd control=table.ctl 报错信息： SQL*Loader: Release 10.2.0.5.0 - Production on Fri Nov 1 03:34:15 2013 Copyright (c) 1982, 2007, Oracle. All rights reserved. SQL*Loader-350: Syntax error at line 4. Expecting keyword INTO, found keyword fields. fields terminated by ',' optionally enclosed by '"'

Answer 1

sqlldr时高让亩戚森指定一下log文件，然后看log里有具体错误原因，一滑和般就是数据不规范所致，不规范的数据会写到.bad后缀文件里
给你个参数文件模板，自己检查一下：

UNRECOVERABLE
load data
infile '4.txt'
append into table
fields terminated by "|" trailing nullcols
(
CONFORM_INDPARTY_ID ,
CONFIRM_IND ,
MAN_CONFORM_IND ,
ACTIVE_IND ,
POSTEMP_IND
)