这个问题官方解释是 更新的时间段超过了最后个分区。处理方法是增加新分区。
可我这个不是
Update T_base_ProUser_fail x
Set x.f_Expectenddate = (Select e.f_Endtime From t_Gather_Expect e Where x.f_Lotid=e.f_Lotteryid And x.f_Expect=e.f_Expect)
min() max() T_base_ProUser_fail 这个表的最大和最小时间 都没有超出过范围。
Update T_base_ProUser_fail x
Set x.f_Expectenddate = (Select e.f_Endtime From t_Gather_Expect e Where x.f_Lotid=e.f_Lotteryid And x.f_Expect=e.f_Expect)
Where X.f_Expectenddate > to_date('2009-06-01','YYYY-MM-DD')
缩小时间访问也如此!
新建个表来看下
CREATE TABLE T_BASE_PROUSER_FAILED AS SELECT * FROM t_Base_Prouser_Fail;
Update T_BASE_PROUSER_FAILED x
Set x.f_Expectenddate =
(Select e.f_Endtime From t_Gather_Expect e Where x.f_Lotid=e.f_Lotteryid And x.f_Expect=e.f_Expect And E.f_Endtime>to_date('2009-06-01','YYYY-MM-DD'))
Where X.f_Expectenddate > to_date('2009-06-01','YYYY-MM-DD');
Commit;
没问题!
再查看原来的分区表代码
PARTITION P200901 VALUES LESS THAN (TO_DATE(' 2009-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
COMPRESS
TABLESPACE STAT
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
),
每个子分区都带有压缩的标志!
估计因为压缩带来错误吧!