| |
Problem Description:
Working kettle used to extract the data from the original database to the standard library, an error in extraction process: [ORA-14400: inserted partition key does not map to any partition]
Resolution process:
After Baidu, ORA-14400 is found to have a problem with the partition table.
1. Determine whether the table has been added to the partition table.
select partition_name, high_value from user_tab_partitions t where table_name = 'table_name';
2. The name of the partition table field query binding.
select * from user_part_key_columns t where name = 'table_name';
3. Check the specific circumstances of the current partition table
select * from user_tab_partitions t where table_name = 'table_name';
4. The lookup table partition field maximum binding. NOTE: table_name here should be the current table corresponding to the original library in the source table.
select max (key_column) from table_name t;
5. query to the partition table to bind the maximum field into the current table test, found an error.
insert into table_name (table_column1, table_column2, ......, key_column) values (value1, value2, ......, key_value);
6. After the above aspects of the data source table to determine the error occurred, and since the time span of erroneous data is greater than the range of the current partition, causing ORA-14400 error occurred, but since the data must be retained, so the extended partition table.
7. extend the current partition table to ensure that the maximum range of more than bound fields.
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. When the kettle used again successfully extracted decimated. |
|
|
|