An interval partition table structure is just created, then try to import the data from exported dump file. It causes ORA-14300 error. The same error occurs when insert records from another online backup table:
SQL> insert into tbl_test select * from tbl_test_old;
insert into tbl_test select * from tbl_test_old;
ERROR at line 1:
ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions
There are NULL values in partition key column.
Update NULL values of partition key column with non-null values, or remove those invalid records from source data.
Please note there are possible 1048575 partitions or sub-partitions for the partition key:
$ oerr ora 14300
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.