oracle分区表分区自动插入空值问题

oracle11g新功能自动分区，如果插入的数据在分区列上找不到对应的分区，那么就会根据分区列的值自动创建分区，但是如果在分区列上传人空值，就会出现ORA-14300报错：

创建测试分区表
create table t_range2 (id number not null PRIMARY KEY, test_date date)
partition by range (test_date) interval (numtoyMinterval (1,'MONTH'))
(
  partition p_2017_01_01 values less than (to_date('2017-01-01', 'yyyy-mm-dd'))
);

插入数据：

SQL> insert into t_range2 values(10,sysdate);

1 row created.
 
SQL> commit;

Commit complete.

SQL> insert into t_range2 values(10,null);
insert into t_range2 values(10,null)
            *
ERROR at line 1:
ORA-14300: partitioning key maps to a partition outside maximum permitted
number of partitions


SQL> insert into t_range2 values(10,'');
insert into t_range2 values(10,'')
            *
ERROR at line 1:
ORA-14300: partitioning key maps to a partition outside maximum permitted
number of partitions

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30373263/viewspace-2134640/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30373263/viewspace-2134640/