ORA-14300

ORA-14300

Table of Contents

1 错误信息

ORA-12008: error in materialized view or zonemap refresh path
ORA-14300: partitioning key maps to a partition outside maximum permitted
number of partitions

2 原因分析

14300, 00000, "partitioning key maps to a partition outside maximum permitted number of partitions"
// *Cause:  The row inserted had a partitioning key that maps to a partition number greater than 1048575
// *Action  Ensure that the partitioning key falls within 1048575 partitions or subpartitions.

从Oracle 提示来看,是说分区的总个数走过了1048575.

这里补充另外一个原因: 分区字段有空值时也会报这个错误。

Author: halberd.lee

Created: 2020-05-21 Thu 13:29

Validate

原文地址:https://www.cnblogs.com/halberd-lee/p/12930176.html