ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions
验证oracle新特性,在线转换非分区为分区表的过程中,出现如下报错
SQL> alter table t modify 2 partition by range (object_id) interval (1000) 3 ( 4 partition p1 values less than (100) 5 ) online 6 update indexes; alter table t modify * ERROR at line 1: ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions
原因是因为分区字段中包含一个空值,导致插入报错,手工更新空值再次转换无报错
SQL> update T set object_id=1 where object_id is null ; 1 row updated. SQL> commit; Commit complete SQL> alter table t modify 2 partition by range (object_id) interval (1000) 3 ( 4 partition p1 values less than (1000) 5 ) online 6 update indexes; Table altered.