ctrl文件:
LOAD DATA
INTO TABLE IRM_DESTINATION
append
FIELDS TERMINATED BY ""
(
DESTINATION_ID ,
CARRIER_ID ,
COUNTRY_ID ,
DESTINATION_NAME ,
COUNTRY_CODE ,
AREA_CODE char(4000) ,
DEST_CITY ,
DEST_CARRIER ,
CALLEE_TYPE ,
CALLEE_SUB_TYPE ,
SERVICE_TYPE ,
EFFECT_DATE ,
EXPIRE_DATE ,
UPDATE_DATE date 'Mon DD YYYY HH:MI:SSAM',
UPDATE_BY
)
要导入的数据如下:
102114710103ARGENTINA BUENOS AIRES FIXED5411012008070320490101102114710103ARGENTINA BUENOS AIRES FIXED5411012008070320490101Jan 16 2009 9:28:47AM可是结果总是报错:
Record 1: Rejected - Error on table IRM_DESTINATION, column UPDATE_DATE.
ORA-01843: not a valid month结果是一行都没导进去,读了51行,都是一样的错误。
LOAD DATA
INTO TABLE IRM_DESTINATION
append
FIELDS TERMINATED BY ""
(
DESTINATION_ID ,
CARRIER_ID ,
COUNTRY_ID ,
DESTINATION_NAME ,
COUNTRY_CODE ,
AREA_CODE char(4000) ,
DEST_CITY ,
DEST_CARRIER ,
CALLEE_TYPE ,
CALLEE_SUB_TYPE ,
SERVICE_TYPE ,
EFFECT_DATE ,
EXPIRE_DATE ,
UPDATE_DATE date 'Mon DD YYYY HH:MI:SSAM',
UPDATE_BY
)
要导入的数据如下:
102114710103ARGENTINA BUENOS AIRES FIXED5411012008070320490101102114710103ARGENTINA BUENOS AIRES FIXED5411012008070320490101Jan 16 2009 9:28:47AM可是结果总是报错:
Record 1: Rejected - Error on table IRM_DESTINATION, column UPDATE_DATE.
ORA-01843: not a valid month结果是一行都没导进去,读了51行,都是一样的错误。
这一行日期格式化错误