Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ORA-14400: inserted partition key does not map to any partition     - Those things packaged using Gradle to Android (Programming)

- Android in the coordinate system and a method to obtain the coordinates (Programming)

- How do I use Linux development environment (Linux)

- To create a Linux server network security (Linux)

- Linux environment to build next Cocos2dx-3.3.1 (Linux)

- Linux, how to filter, split, and merge pcap file (Linux)

- Java transient keyword (Programming)

- Oracle 12C truncate table cascade (Database)

- MySQL Basic tutorial: About varchar (N) (Database)

- Python 2.7.9 Installation on Linux CentOS 6.6 (Linux)

- Vim useful plugin: YouCompleteMe (Linux)

- Android Fragment really fully resolve (Programming)

- Oracle Linux 5.5 (64bit) Install Oracle 11gR2 RAC detailed tutorial (Database)

- Ubuntu Learning Advanced article - to teach you to further enhance system security (Linux)

- About AWR More Description (Database)

- STL in the list of erase () method (Programming)

- Linux disk virtualization (Linux)

- Linux package management (Linux)

- Enterprise-class GitHub warehousing environment build (Server)

- How the program is executed (Programming)

 
         
  ORA-14400: inserted partition key does not map to any partition
     
  Add Date : 2018-11-21      
         
         
         
  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.
     
         
         
         
  More:      
 
- Let Markdown code syntax highlighting and support Django1.6 (Linux)
- Python in yield (Programming)
- apt-get install openstack pkg Troubleshooting (Linux)
- Spring Data JPA @EnableJpaRepositories configuration in detail (Programming)
- Default permissions Linux file and directory permissions and hide - umask, chattr, lsattr, SUID, SGID, SBIT, file (Linux)
- iOS9 new feature - stacked view UIStackView (Programming)
- How to configure a development environment elegant Lua (Linux)
- CentOS6 5 Configure SSH password Free (Linux)
- I use the desktop environment in GNU / Linux combination tool (Linux)
- How to restart after a crash Cinnamon (Linux)
- Python regular expressions: how to use regular expressions (Programming)
- The difference between statement and preparedStatement of the jdbc (Database)
- How to prevent page five invisible killer (Linux)
- Debian users to install FFmpeg 2.2.2 (Linux)
- How to install Linux Go Language (Linux)
- Hibernate in profile (Database)
- Spring WebSocket Comments (Programming)
- Linux environment SSH login password instead of using the RSA Certificate (Linux)
- Three binary tree traversal (recursive, non-recursive traversal and Morris) (Programming)
- Sorting algorithm of dichotomy (binary) insertion sort algorithm (Programming)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.