inserted partition key does not map to any partition
insert into di_source.zh_m_etl_ti_tlw_toll
(
DEAL_DATE , --处理时间
BUSINESS_TYPE , --结算种类
BILL_TYPE , --话单类型(POC,PTC,MOC...etc)
SWITCH_CODE , --交换机标号
)
select /*+parallel(a,8)*/
to_number(DEAL_DATE), --处理时间
BUSINESS_TYPE , --结算种类
BILL_TYPE , --话单类型(POC,PTC,MOC...etc)
SWITCH_CODE , --交换机标号
from etl_ti_tlw_toll_his a
where substr(deal_date,1,8)='20071206'
zh_m_etl_ti_tlw_toll分区表创建语句如下:
create table zh_m_ETL_TI_TLW_TOLL
(
DEAL_DATE number(10) , --处理时间
BUSINESS_TYPE varchar2(20) , --结算种类
BILL_TYPE VARCHAR2(20) , --话单类型(POC,PTC,MOC...etc)
SWITCH_CODE VARCHAR2(20) --交换机标号
)
tablespace TBS_SOUR13
partition by range(deal_date)
subpartition by list(switch_code)
SUBPARTITION TEMPLATE(
subpartition s_0410 values('410') tablespace TBS_SOUR13,
subpartition s_0411 values('411') tablespace TBS_SOUR13,
subpartition s_0412 values('412') tablespace TBS_SOUR13,
subpartition s_0413 values('413') tablespace TBS_SOUR13,
subpartition s_0417 values('417') tablespace TBS_SOUR13,
subpartition s_0421 values('421') tablespace TBS_SOUR13,
subpartition s_0498 values('498') tablespace TBS_SOUR13,
subpartition s_0499 values('499') tablespace TBS_SOUR13
)
(PARTITION zh_m_etl_toll_20071201 VALUES LESS THAN (20071202),
PARTITION zh_m_etl_toll_20071202 VALUES LESS THAN (20071203),
PARTITION zh_m_etl_toll_20071203 VALUES LESS THAN (20071204),
PARTITION zh_m_etl_toll_20071204 VALUES LESS THAN (20071205),
PARTITION zh_m_etl_toll_20071205 VALUES LESS THAN (20071206),
PARTITION zh_m_etl_toll_20071206 VALUES LESS THAN (20071207),
PARTITION zh_m_etl_toll_20071207 VALUES LESS THAN (20071208),
PARTITION zh_m_etl_toll_20071208 VALUES LESS THAN (20071209),
PARTITION zh_m_etl_toll_20071209 VALUES LESS THAN (20071210),
PARTITION zh_m_etl_toll_20071210 VALUES LESS THAN (20071211),
PARTITION zh_m_etl_toll_20071211 VALUES LESS THAN (20071212),
PARTITION zh_m_etl_toll_20071212 VALUES LESS THAN (20071213),
PARTITION zh_m_etl_toll_20071213 VALUES LESS THAN (20071214),
PARTITION zh_m_etl_toll_20071214 VALUES LESS THAN (20071215),
PARTITION zh_m_etl_toll_20071215 VALUES LESS THAN (20071216),
PARTITION zh_m_etl_toll_20071216 VALUES LESS THAN (20071217),
PARTITION zh_m_etl_toll_20071217 VALUES LESS THAN (20071218),
PARTITION zh_m_etl_toll_20071218 VALUES LESS THAN (20071219),
PARTITION zh_m_etl_toll_20071219 VALUES LESS THAN (20071220),
PARTITION zh_m_etl_toll_20071220 VALUES LESS THAN (20071221),
PARTITION zh_m_etl_toll_20071221 VALUES LESS THAN (20071222),
PARTITION zh_m_etl_toll_20071222 VALUES LESS THAN (20071223),
PARTITION zh_m_etl_toll_20071223 VALUES LESS THAN (20071224),
PARTITION zh_m_etl_toll_20071224 VALUES LESS THAN (20071225),
PARTITION zh_m_etl_toll_20071225 VALUES LESS THAN (20071226),
PARTITION zh_m_etl_toll_20071226 VALUES LESS THAN (20071227),
PARTITION zh_m_etl_toll_20071227 VALUES LESS THAN (20071228),
PARTITION zh_m_etl_toll_20071228 VALUES LESS THAN (20071229),
PARTITION zh_m_etl_toll_20071229 VALUES LESS THAN (20071230),
PARTITION zh_m_etl_toll_20071230 VALUES LESS THAN (20071231),
PARTITION zh_m_etl_toll_20071231 VALUES LESS THAN (20080101));
插入时报错:ORA-14400: inserted partition key does not map to any partition
我查了表分区好像但是分区里也有与'20071206'相对应的分区呀,按理说应该是没问题的,大家帮忙看下,谢谢
|
