ORA-14758: Last partition in the range section cannot be dropped

今天发现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