Hi,
I am using Oracle Oracle Database 11g Enterprise Edition Release 11.2.0.3.0.
Very strangely when I am executing an merge statement it is throwing me an error ORA-14400: inserted partition key does not map to any partition.
But my target table FACT_INVN_DTL is range partitioned by interval - PARTITION BY RANGE ("SNAP_DATE_TS_TIME_REF_ID") INTERVAL (1)( which should create new partitions automatically)
Below is the DDL structure of the table
CREATE TABLE "FACT_INVN_DTL"
( "SNAP_DATE_TS_TIME_REF_ID" NUMBER NOT NULL ENABLE,
.
.
.
"UCA_JDA_PRODUCT_FLAG" VARCHAR2(100),
CONSTRAINT "PK_FCT_INVENTORY_DETAILS" PRIMARY KEY ("SNAP_DATE_TS_TIME_REF_ID", "...", ".....")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RF_DMT_INDEX" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "...."
PARTITION BY RANGE ("SNAP_DATE_TS_TIME_REF_ID") INTERVAL (1)
(PARTITION "P_D20120704" VALUES LESS THAN (20000000020120704) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS NOLOGGING
STORAGE(INITIAL 163840 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "...." ) ENABLE ROW MOVEMENT ;
Any idea ?