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

Question

建表的时候明明建 分区了
在 ACCT_ITEM_MONTH 字段上建立的
MON01 '01'
MON02 '02'
MON03 '03'
MON04 '04'
MON05 '05'
MON06 '06'
MON07 '07'
MON08 '08'
MON09 '09'
MON10 '10'
MON11 '11'
MON12 '12'
INSERT INTO DA.TAUA_MPOP_STOCK_MON PARTITION(MON03)  
  (TIME_CD,
   ACCT_ITEM_MONTH,
   STD_AREA_ID,
   STD_BRAND_CD,
   CT_CUST_TYPE_CD,
   STD_SP_CORP_CD,
   BUSINESS_TYPE,
   USE_NUM,
   CDR_INCOME,
   ETL_CYCLE_ID,
   ETL_TIME)
  SELECT TIME_CD, --ê±??±à??
         ACCT_ITEM_MONTH, --?ê????·Y
         STD_AREA_ID, --±ê×?μ???±êê?
         STD_BRAND_CD, --?·??±êê?
         CT_CUST_TYPE_CD, --±ê×??ˉí??í?§ààDí±à??
         STD_SP_CORP_CD, --±ê×?SP1???CD′ú??
         BUSINESS_TYPE, --òμ??ààDí
         SUM(USE_NUM), --ê1ó?ó??§êy
         SUM(CDR_INCOME), --??·??êμ￥ê?è?
         200903,
         SYSDATE
    FROM TMPTAB.TMP_TAUA_C_023_200903_27_B
   GROUP BY TIME_CD,
            ACCT_ITEM_MONTH,
            STD_AREA_ID,
            STD_BRAND_CD,
            CT_CUST_TYPE_CD,
            STD_SP_CORP_CD,
            BUSINESS_TYPE
            

Answer 1

改成下面的语句试一下：
INSERT INTO DA.TAUA_MPOP_STOCK_MON  
  (TIME_CD, 
  ACCT_ITEM_MONTH, 
  STD_AREA_ID, 
  STD_BRAND_CD, 
  CT_CUST_TYPE_CD, 
  STD_SP_CORP_CD, 
  BUSINESS_TYPE, 
  USE_NUM, 
  CDR_INCOME, 
  ETL_CYCLE_ID, 
  ETL_TIME,
  ACCT_ITEM_MONTH) 
  SELECT TIME_CD, --ê±??±à?? 
        ACCT_ITEM_MONTH, --?ê????·Y 
        STD_AREA_ID, --±ê×?μ???±êê? 
        STD_BRAND_CD, --?·??±êê? 
        CT_CUST_TYPE_CD, --±ê×??ˉí??í?§ààDí±à?? 
        STD_SP_CORP_CD, --±ê×?SP1???CD′ú?? 
        BUSINESS_TYPE, --òμ??ààDí 
        SUM(USE_NUM), --ê1ó?ó??§êy 
        SUM(CDR_INCOME), --??·??êμ￥ê?è? 
        200903, 
        SYSDATE,
        to_char(sysdate,'dd') 
    FROM TMPTAB.TMP_TAUA_C_023_200903_27_B 
  GROUP BY TIME_CD, 
            ACCT_ITEM_MONTH, 
            STD_AREA_ID, 
            STD_BRAND_CD, 
            CT_CUST_TYPE_CD, 
            STD_SP_CORP_CD, 
            BUSINESS_TYPE