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

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

Python ctypes access violation with const pointer arguments -