错误码：117
错误内容：范围分区没有包含MAXVALUE,存在定位不到分区的情况
错误级别: WARN
原因：创建分区表时, 没有指定最大值
示例

SQL> CREATE  TABLE  callinfo( 
    caller CHAR(15), 
    callee CHAR(15),
    time    DATETIME,
    duration INT
)
PARTITION BY RANGE(time)(
PARTITION p1 VALUES LESS THAN ('2010-04-01'),
PARTITION p2 VALUES LESS THAN ('2010-07-01'),
PARTITION p3 VALUES LESS THAN ('2010-10-01')
);
warning: Range partition not include maxvalue,partition may be not located
executed successfully
used time: 28.599(ms). Execute id is 602.
SQL> 

解决方法
添加MAXVALUE

CREATE  TABLE  callinfo( 
    caller CHAR(15), 
    callee CHAR(15),
    time    DATETIME,
    duration INT
)
PARTITION BY RANGE(time)(
PARTITION p1 VALUES LESS THAN ('2010-04-01'),
PARTITION p2 VALUES LESS THAN ('2010-07-01'),
PARTITION p3 VALUES LESS THAN ('2010-10-01'),
PARTITION p4 VALUES LESS THAN (MAXVALUE)  -- 不属于上面分区的数据都会存到该分区上
);