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.