0 0

sql loader 报错ORA-01841: (full) year must be between -4713 and +999910

CREATE TABLE "MSSAPP"."MC_INT_RATE_CDE"
   ( "INT_RATE_CDE_ID" NUMBER(18,0),
"CMPNY_CDE" VARCHAR2(10),
"INT_RATE_CDE" VARCHAR2(20),
"PRIMY_INT_RATE_CDE_NAM" VARCHAR2(100),
"LAST_CMPNY_INPT_DATE" TIMESTAMP (6),
"REC_VER_NUM" NUMBER(18,0) NOT NULL ENABLE,
"INIT_TIME" TIMESTAMP (6) NOT NULL ENABLE,
"LAST_UPD_TIME" TIMESTAMP (6) NOT NULL ENABLE,
"LAST_UPD_BY" VARCHAR2(20) NOT NULL ENABLE,
"TAG_SEQ" NUMBER(18,0) NOT NULL ENABLE
   )


Record 1: Rejected - Error on table MSSAPP.MC_INT_RATE_CDE, column LAST_CMPNY_INPT_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Record 2: Rejected - Error on table MSSAPP.MC_INT_RATE_CDE, column LAST_CMPNY_INPT_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Record 3: Rejected - Error on table MSSAPP.MC_INT_RATE_CDE, column LAST_CMPNY_INPT_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Record 4: Rejected - Error on table MSSAPP.MC_INT_RATE_CDE, column LAST_CMPNY_INPT_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Record 5: Rejected - Error on table MSSAPP.MC_INT_RATE_CDE, column LAST_CMPNY_INPT_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0


Table MSSAPP.MC_INT_RATE_CDE:
  0 Rows successfully loaded.
  5 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

数据文件,控制文件,日志都在附件里,查了半天也没有看出什么问题。。请帮忙看看
2010年2月26日 14:48

1个答案 按时间排序 按投票排序

0 0

我下载了你的文件测试了N次,结论是你的dat文件有问题。我手工编写了一个dat文件是能够正确加载到数据库中的。

你的dat数据存在乱码问题,你可以只加载前4个非日期字段测试,我发现前4个字段加载到数据库中是乱码.。

That's all, bye!

2010年3月12日 17:07

相关推荐

Global site tag (gtag.js) - Google Analytics