我给数据库中的表添加今年1月31号和2月份的按天分区,没想到遭遇ORA-14074错误。请各位大侠帮忙看看到底是怎么一会儿事儿
sys@SVBI> ALTER TABLE MIGDS.RESULT_LOG ADD PARTITION "P_20150201" VALUES LESS THAN (TO_DATE(' 20150202 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
ALTER TABLE MIGDS.RESULT_LOG ADD PARTITION "P_20150201" VALUES LESS THAN (TO_DATE(' 20150202 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
*
ERROR at line 1:
ORA-14074: partition bound must collate higher than that of the last partition
查询表发现指定的分区并没有存在
sys@SVGBI> select table_name,partition_name,high_value,tablespace_name from all_tab_partitions where table_name='RESULT_LOG' order by partition_position;
TABLE_NAME PARTITION_NAME HIGH_VALUE TABLESPACE_NAME
---------- --------------- --------------- ---------------
RESULT_LOG P_20150123 '20150124' MIGDS
RESULT_LOG P_20150124 '20150125' MIGDS
RESULT_LOG P_20150125 '20150126' MIGDS
RESULT_LOG P_20150126 '20150127' MIGDS
RESULT_LOG P_20150127 '201