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

Problem description:

Insert to a partitioned table from the application is getting failed with following error message.

java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition

Solution Description

First of you have to check whether in your partitioned table has a default partition. Default partition means all the records which are not belongs to any of the other partition will get inserted into the default partition. The range will be specified with a limit of MAXVALUE.

If this partition did not belong to your table, you will have to add the partition using alter table command.

ALTER TABLE “MED_AUD_DOC"

ADD PARTITION "P_DEFAULT" VALUES LESS THAN (MAXVALUE)  

STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "TAB_MED_2XL"

LOB ("DOCUMENT") STORE AS SECUREFILE ( TABLESPACE "LOB_MEDI_2XL" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NONE

CACHE NOCOMPRESS DEDUPLICATE LOB STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;

Try it
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google