---
title: "ORA-14406: 更新的分区关键字在最高合法分区关键字之外－－压缩的标志"
author: "winzenghua"
date: "2009-09-07T16:00:00Z"
tags: []
slug: "ora-14406"
draft: false
lastmod: "2009-09-07T16:00:00Z"
id: 987855
url: "https://java4gis.iteye.com/blog/987855"
---

这个问题官方解释是 更新的时间段超过了最后个分区。处理方法是增加新分区。

可我这个不是

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 &gt; 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&gt;to\_date('2009-06-01','YYYY-MM-DD'))  
Where X.f\_Expectenddate &gt; 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  
),

每个子分区都带有压缩的标志！

估计因为压缩带来错误吧！