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
创建测试分区表
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博客 ” ，链接：https://blog.itpub.net/30373263/viewspace-2134640/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
