ORA-14400: Inserted Partition Key Does Not Map To Any Partition
Error
While inserting data to a partitioned table, got below error.
SQL> insert into TEST_RANGE values(to_date('24032020','ddmmyyyy'),100);
insert into TEST_RANGE values(to_date('24032020','ddmmyyyy'),100);
*
ERROR at line 1:
ORA-14400: inserted partition key does not map to any partition
Cause
Error due to High partition range is not valid with the value you are using in Insert Operation.
Solution
You need to make a valid partition for inserting the data into the Partition Table
You can check partition of table with its range value with following Query:
SQL> select partition_name,high_value from dba_tab_partitions where table_name='TEST_RANGE';
PARTITION_NAME HIGH_VALUE -------------- -------------------------------------------------------------------------------- P3 TO_DATE(' 2020-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA P2 TO_DATE(' 2020-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA P1 TO_DATE(' 2020-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
For More Detail regarding Parttion table, use following query:
select partition_name,column_name,high_value,partition_position
from ALL_TAB_PARTITIONS a , ALL_PART_KEY_COLUMNS b
where table_name='YOUR_TABLE' and a.table_name = b.name;