Answer the question
In order to leave comments, you need to log in
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)
);
ORA-14400 inserted partition key does not map to any partition
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question