ORA-14400: INSERTED partition keywords are not mapped to any partition, ora-14400 keywords

ORA-14400: INSERTED partition keywords are not mapped to any partition, ora-14400 keywords

Problem description:

When kettle is used to extract data from the original Library to the standard library, an error is reported during the extraction process: ORA-14400: INSERTED partition keywords are not mapped to any partition]

Solution Process:

After Baidu, it was found that ORA-14400 is a problem in Table Partitioning.

1. Check whether the table partition has been added to the table.

select partition_name,high_value from user_tab_partitions t where table_name='table_name';

2. query the name of the field bound to the table partition.

select * from user_part_key_columns t where name='table_name';

3. view the partition details of the current table.

select * from user_tab_partitions t where table_name='table_name';

4. query the maximum value of the field bound to the table partition. Note: table_name here should be the source table in the original database corresponding to the current table.

select max(key_column) from table_name t;

5. Insert the maximum value of the queried table partition binding field to the current table for testing. An error is reported.

insert into table_name(table_column1,table_column2,......,key_column) values(value1,value2,......,key_value);

6. after the above steps to determine the source table error data, and because the time span of the error data is greater than the range of the current partition, resulting in ORA-14400 error, but because the data must be retained, therefore, table partitions are extended.

7. Expand the partitions of the current table to ensure that the range is greater than the maximum value of the bound field.

alter table  table_name add partition part_key_column_029 values less than (to_date('2029-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'))　　　　　　　tablespace tablespace_name　　　　　　　pctfree 10　　　　　　  initrans 1　　　　　　　maxtrans255,......,alter table  table_name add partition part_key_column_049 values less than (to_date('2049-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'))
　　　　　　　tablespace tablespace_name　　　　　　　pctfree 10　　　　　　  initrans 1　　　　　　　maxtrans255,

8. End. Kettle is used for extraction again.