INTERVAL RANGE Partition Giving ORA-14400
Last updated on JULY 18, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
The following INSERT fails for a INTERVAL RANGE PARTITION table:
commit;insert into test1 values (20100401000000000000001,'')
ERROR at line 1:
ORA-14400: inserted partition key does not map to any partition
The following table has been defined:
PARTITION BY RANGE(id)
INTERVAL(1000000000000000) STORE IN (users)
(PARTITION p1 VALUES LESS THAN (1000000000000000)
PARTITION p2 VALUES LESS THAN (2000000000000000)
PARTITION p3 VALUES LESS THAN (30000000000000000)
This is a normal Interval Partitioned Table:
At this point I will quote from the Data Warehousing Documents regarding INTERVAL PARTITIONs.
So, the above table should be able to cope with the following SQL INSERT Statements. These are detailed below in the CAUSE section.
SQL Used to validate new partition created:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms