oracle 9208中在原有分区表中添加2013年分区,脚本如下:
ALTER TABLE ABC ADD PARTITION M201301 VALUES LESS THAN (2013, 2) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201302 VALUES LESS THAN (2013, 3) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201303 VALUES LESS THAN (2013, 4) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201304 VALUES LESS THAN (2013, 5) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201305 VALUES LESS THAN (2013, 6) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201306 VALUES LESS THAN (2013, 7) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201307 VALUES LESS THAN (2013, 8) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201308 VALUES LESS THAN (2013, 9) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201309 VALUES LESS THAN (2013, 10) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201310 VALUES LESS THAN (2013, 11) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201311 VALUES LESS THAN (2013, 12) LOGGING NOCOMPRESS TABLESPACE DATA13;
ALTER TABLE ABC ADD PARTITION M201312 VALUES LESS THAN (2014, 1) LOGGING NOCOMPRESS TABLESPACE DATA13;
在执行到最后一行时,报错:
ALTER TABLE ABC ADD PARTITION M201312 VALUES LESS THAN (2014, 1) LOGGING NOCOMPRESS TABLESPACE DATA13
*
第 1 行出现错误:
ORA-14074: 分区界限必须调整为高于最后一个分区界限
执行完以后,发现M201312分区已经建立出来,可以正常使用。
但是这个错误,没法解释,郁闷啊!
请教高手帮助分析,多谢!