Loading

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.

 

posted @ 2022-12-31 23:55  李行行  阅读(717)  评论(0编辑  收藏  举报