database partitioning - Oracle Partition - Error ORA14400 - inserted partition key does not map to any partition -
i'm trying insert information in partition table, don't know i'm doing wrong! show me error: ora-14400: inserted partition key not map partition
"
the table dba_tab_partitions
shows informations below:
1 pdia_98_20091023 0 2 pdia_98_20091022 0 3 pdia_98_20091021 0 4 pdia_98_20091020 0 5 pdia_98_20091019 0
please me rs
select partition_name,column_name,high_value,partition_position all_tab_partitions , all_part_key_columns b table_name='your_table' , a.table_name = b.name;
this query lists column name used key , allowed values. make sure, insert allowed values(high_value
). else, if default partition defined, go there.
edit:
i presume, table ddl this.
create table he0_dt_inf_interfaz_mes ( cod_pais number, fec_data number, interfaz varchar2(100) ) partition range(cod_pais, fec_data) ( partition pdia_98_20091023 values less (98,20091024) );
which means had created partition multiple columns holds value less composite range (98,20091024);
that first cod_pais <= 98
, fec_data < 20091024
combinations , result:
98, 20091024 fail 98, 20091023 pass 99, ******** fail 97, ******** pass < 98, ******** pass
so below insert
fails ora-14400; because (98,20091024)
in insert
equal 1 in ddl
not less it.
sql> insert he0_dt_inf_interfaz_mes(cod_pais, fec_data, interfaz) values(98, 20091024, 'cta'); 2 insert he0_dt_inf_interfaz_mes(cod_pais, fec_data, interfaz) * error @ line 1: ora-14400: inserted partition key not map partition
but, attempt (97,20091024), goes through
sql> insert he0_dt_inf_interfaz_mes(cod_pais, fec_data, interfaz) 2 values(97, 20091024, 'cta'); 1 row created.
Comments
Post a Comment