Oracle Partition - Error ORA14400 - inserted partition key does not map to any partition

Question

I m trying to insert information in a partition table  but I don t know what I m doing wrong  Show me this error  ORA-14400  inserted partition key does not map to any partition   The table dba tab partitions shows this informations below   1   PDIA 98 20091023    0 2   PDIA 98 20091022    0 3   PDIA 98 20091021    0 4   PDIA 98 20091020    0 5   PDIA 98 20091019    0   Please help me rs

User · Answer

For this issue need to add the partition for date column values, If last partition 20201231245959, then inserting the 20210110245959 values, this issue will occurs.

For that need to add the 2021 partition into that table

ALTER TABLE TABLE_NAME ADD PARTITION PARTITION_NAME VALUES LESS THAN (TO_DATE('2021-12-31 24:59:59', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) NOCOMPRESS

User · Answer

select partition name column name high value partition position from ALL TAB PARTITIONS a   ALL PART KEY COLUMNS b  where table name  YOUR TABLE  and a table name   b name    This query lists the column name used as key and the allowed values  make sure  you insert the allowed values high value   Else  if default partition is defined  it would go there     EDIT   I presume  your TABLE DDL would be like this   CREATE TABLE HE0 DT INF INTERFAZ MES         COD PAIS NUMBER      FEC DATA NUMBER      INTERFAZ VARCHAR2 100        partition BY RANGE COD PAIS  FEC DATA          PARTITION PDIA 98 20091023 VALUES LESS THAN  98 20091024         Which means I had created a partition with multiple columns which holds value less than the composite range  98 20091024    That is first COD PAIS  lt   98 and Also FEC DATA  lt  20091024  Combinations And Result   98  20091024     FAIL 98  20091023     PASS 99               FAIL 97               PASS   lt  98               PASS     So the below INSERT fails with ORA-14400  because  98 20091024  in INSERT is EQUAL to the one in DDL but NOT less than it   SQL gt  INSERT INTO HE0 DT INF INTERFAZ MES COD PAIS  FEC DATA  INTERFAZ                                    VALUES 98  20091024   CTA     2 INSERT INTO HE0 DT INF INTERFAZ MES COD PAIS  FEC DATA  INTERFAZ                ERROR at line 1  ORA-14400  inserted partition key does not map to any partition   But  we I attempt  97 20091024   it goes through   SQL gt  INSERT INTO HE0 DT INF INTERFAZ MES COD PAIS  FEC DATA  INTERFAZ    2                                    VALUES 97  20091024   CTA     1 row created

[oracle] Oracle Partition - Error ORA14400 - inserted partition key does not map to any partition

Examples related to oracle

Examples related to database-partitioning