• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 13724
  • Last Modified:

ORA-14400: inserted partition key does not map to any partition

I got  ORA-14400: inserted partition key does not map to any partition .

Here is sample of my code.  What is wrong?  Thanks.
PARTITION BY RANGE (year, month)
(  
  PARTITION PART_DM_2006_1 VALUES LESS THAN (2006, 01)
    NOLOGGING
    COMPRESS
    TABLESPACE ...
......
               ),  
0
ewang1205
Asked:
ewang1205
1 Solution
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
do you have a partition into which values other than matching ones go like :

PARTITION PMAX VALUES LESS THAN (MAXVALUE,MAXVALUE) for your table.

the error which you have got will come if you trying to insert a record whose values does not match the values less than clause of any of the partitions which your table is having.

if you table is missing the MAXVALUE partition, then adding that will resolve the error.

Thanks
0
 
ewang1205Author Commented:
Goog job, nav_kum_v!  
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now