N
N
Nikolay Baranenko2017-08-11 00:08:09
Oracle
Nikolay Baranenko, 2017-08-11 00:08:09

Why does ORA-14400 inserted partition key does not map to any partition occur?

Hello.
For example, I created a table with range partitions by id field

-- Create table
create table UM_TASKS_NEW2
(
  id         INTEGER not null,
  id_task    INTEGER,
  status     VARCHAR2(50),
  result     CLOB,
  start_date DATE,
  end_date   DATE,
  duration   FLOAT
)
partition by range (ID)
(
  partition UM_TASKS_ID_1 values less than (1)
,
partition UM_TASKS_ID_2 values less than (5) 
);

filled with data, and when trying to fill in a line with ID=5, an error was reproduced
ORA-14400 inserted partition key does not map to any partition

Previously worked with a breakdown by the start_date date field for each day.
Insert with a new date automatically created a new one.
With the Number field, the partition will not be automatically created in this case?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Eugene, 2017-08-11
@drno-reg

Because "less than", but not "less than or equal to" :) Create another partition less than (6), for example.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question