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
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)
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)) ;