Knowledge Base

Define a corresponding partition for the value you're inserting

ORA-14400: inserted partition key does not map to any partition

You are inserting a value into a partitioned table, but there is no partition defined for the value you are inserting.

First we create a partition table:

create table part_test
(n number)
partition by list
(n)
(
partition part_test_1 values(1) tablespace tools,
partition part_test_2 values(2) tablespace tools
);

SQL> /

Table created.

This table contains 2 partitions, one for values 1 and one for values 2.
We check if we can insert data into the table for which we created partitions:

SQL> insert into part_test values(1);

1 row created.

SQL> insert into part_test values(2);

1 row created.

Now, when we try to insert a value into the table for which no partition is defined, we receive this error:

SQL> insert into part_test values(3);
insert into part_test values(3)
            *
ERROR at line 1:
ORA-14400: inserted partition key does not map to any partition

The solution is to add the requested partition:


SQL> alter table part_test add partition part_test_3 values(3) tablespace tools;

Table altered.

SQL> insert into part_test values(3);

1 row created.
Oracle Gold Partner DbMotive is an Oracle Gold Partner