ORA_14400：插入的分区关键字未映射到任何分区

ORA_14400：插入的分区关键字未映射到任何分区

插入数据的时候报错ORA-14400: inserted partition key does not map to any partition

1.确定该表是否已经添加了表分区

select partition_name,high_value from user_tab_partitions  where table_name='';

2.查看分区基于那个分段

select * from USER_PART_KEY_COLUMNS;

3.添加表分区

alter table xxx add partition P200901 values less than (to_date ('2009-01-31','YYYYMMDD')) tablespace xxxxx;

4.删除表分区

ALTER TABLE sales DROP PARTITION sales_q1_2022;