首页 > 其他分享 >ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

时间:2023-01-01 00:13:29浏览次数:58  
标签:partitioning object partition maximum number 报错 SQL id

验证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.

 

标签:partitioning,object,partition,maximum,number,报错,SQL,id
From: https://www.cnblogs.com/hanglinux/p/17017622.html

相关文章