Wednesday 28 June 2017

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

Problem :- Due to this error you are unable to inset data into a particular table which has partitions.

Cause :- It happened because the data you are trying to insert is  not in range of the partition has been created or NULL value is updated on the column which has partition.

i.e. To have partition on creation_date You must always put Date in the column which is in range and should not insert NULL.

Solution :- To solve the problem, make sure that the partitioning key column data to be inserted does not have any NULL value.


No comments:

Post a Comment