今天发现oracle11g中用oracle自动创建分区的新功能后,删除旧分区报ORA-14758: Last partition in the range section cannot be dropped错误。
oracle对此错误的解释是:
ORA-14758: Last partition in the range section cannot be dropped
Cause: An attempt was made to drop the last range partition of an interval partitioned table.
Action: Do not attempt to drop this partition.
实验如下:
1.创建自动分区的表:
SQL> create table TB_DYNA_TABLE
(
NUM NUMBER,
NAME VARCHAR2(30),
CRT_TIME DATE not null
)
partition by range (CRT_TIME)
interval(numtodsinterval(1,'DAY'))
(PARTITION P20120919 VALUES LESS THAN (TO_DATE(' 2012-0