|
记录 1 被拒绝 - 表 MOD_CDL_PILOT_CELL_1X 出现错误。
ORA-14400 插入的分区关键字未映射到任何分区
sqlldr提示:达到提交点 - 逻辑记录计数 1
如下创建的表分区造成START_TIME为2012-02-29 07:07:28的记录无入插入,出现上面的错误
create table MOD_CDL_PILOT_CELL_1X
(
START_TIME DATE not null,
CITY_ID NUMBER not null,
CITY_NAME VARCHAR2(100),
VENDOR VARCHAR2(100) not null
)
partition by range (START_TIME)
(
partition PART_2011112700 values less than (TO_DATE(' 2011-11-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace CLT_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
minextents 1
maxextents unlimited
),
partition PART_2011112800 values less than (TO_DATE(' 2011-11-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace CLT_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
minextents 1
maxextents unlimited
),
partition PART_2011112900 values less than (TO_DATE(' 2011-11-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace CLT_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
minextents 1
maxextents unlimited
)
);
修改相应的表分区
ALTER TABLE MOD_CDL_PILOT_CELL_1X ADD PARTITION maxpart VALUES LESS THAN (MAXVALUE);
|
|