Wednesday, January 27, 2016

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

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


insert into ldbo.TBLSNPRISKDETAILS (CFIRMNUMBER, CCLIENTCODE, DSAUDADATE, NPRODUCTCODE, NSEGMENTTYPE, NFINANCEAMOUNT, NMARGINAMOUNT, NBILLAMOUNT, NCOLLATERAL, NCOLLATERALBHCUT, NDEMATSTOCK, NDEMATSTOCKBHCUT, NOVERALLPOSITION, NOVERALLPOSITIONBHCUT, NNETMARGIN, NNETMARGINBHCUT, NFOEXPOSURE, NDERIVATIVESNOTIONAL, NOSSALES, NMARGINPERCENTAGE, NMARPERBHCUT, NPOASTOCK, NPOASTOCKBHCUT, NUNREALIZEDAMOUNT, NBHLEVEL, NBHLEVELBHCUT, NMFDEMATSTOCK, NMFDEMATSTOCKBHCUT, NMFPOASTOCK, NMFPOASTOCKBHCUT, NTILLDATEFINANCE, NTILLDATEMARGIN, CSCHEMETYPE, CBRANCHCODE, CCTCLBRANCHCODE, NMFNOTIONAL, CCOMPANYNAME, CCLIENTCATEGORY, NPENDINGACCEPTED, NADHOCCHARGE, NACCRUEDINTEREST, CNEXTRADEDATE, CBDRCODE, NPISAMOUNT, NGLOBALMARGIN, NTOTALSTOCK, NDPCHARGES, NTOTALILLBENSTOCK)
values ('FOR-000001', 'N124349   ', to_date('31-05-2017', 'dd-mm-yyyy'), 0, 0, 267.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 58630.70, 64229.30, 58363.70, 63962.30, 0.00, 0.00, 0.00, 99.54, 99.58, 58630.70, 64229.30, 0.00, 0, 0, 0.00, 0.00, 0.00, 0.00, 267.00, 0.00, 'NORMAL    ', '8002', 'HO    ', 0.00, 'RSL_SELF_RACE_ONLINE', ' ', 0.00, 0.00, 0.00, '02/04/2014', ' ', 0.00, 51034.05, 64229.30, 0.00, 0);

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



 STORAGE(INITIAL 10000M NEXT 1000M)
  TABLESPACE "USR"
  PARTITION BY RANGE ("DSAUDADATE")
(
PARTITION SAUDA_APR values LESS THAN (TO_DATE('01-MAY-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAY values LESS THAN (TO_DATE('01-JUN-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUN values LESS THAN (TO_DATE('01-JUL-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JUL values LESS THAN (TO_DATE('01-AUG-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_AUG values LESS THAN (TO_DATE('01-SEP-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_SEP values LESS THAN (TO_DATE('01-OCT-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_OCT values LESS THAN (TO_DATE('01-NOV-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_NOV values LESS THAN (TO_DATE('01-DEC-2015','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_DEC values LESS THAN (TO_DATE('01-JAN-2016','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_JAN values LESS THAN (TO_DATE('01-FEB-2016','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_FEB values LESS THAN (TO_DATE('01-MAR-2016','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),
PARTITION SAUDA_MAR values LESS THAN (TO_DATE('01-APR-2016','DD-MON-YYYY'))  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M ),



add following
PARTITION SAUDA_MAX values LESS THAN (maxvalue)  TABLESPACE USR STORAGE (INITIAL 100M NEXT 100M )

No comments:

Post a Comment

Followers