ORA-14300: partition keywords map to partitions that exceed the maximum number of partitions allowed

ORA-14300: partition keywords map to partitions that exceed the maximum number of partitions allowed

ORA-14300: partition keywords map to partitions that exceed the maximum number of partitions allowed

ORA-14300: partition keywords map to partitions that exceed the maximum number of partitions allowed

Environment: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production

The object table is an automatic partition table by day:

Partition by range ("START_TIME") INTERVAL (NUMTODSINTERVAL (1, 'day '))

Cause: when the value of START_TIME is NULL, data is inserted into the partition object table. The database does not know which partition to insert the record, leading to an error.

Solution: assign a value to START_TIME. The value cannot be blank. The database automatically saves the data to the corresponding existing partition or creates a new partition to save it.