My Oracle Support Banner

Ora-14314: Resulting List Partition(S) Must Contain Atleast 1 Value While Splitting Partition (Doc ID 314492.1)

Last updated on OCTOBER 29, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 and later
Information in this document applies to any platform.

Symptoms

 You have an partitioned table .

 CREATE TABLE test (deptno number,deptname varchar2(20))
 PARTITION BY LIST (deptname)
 (PARTITION q1_post VALUES ('CLERK', 'MANAGER'), PARTITION q1_highpost VALUES ('DIRECTOR'))

You are trying to split the partition  q1_post in to Partition

You get the following error while trying to spilt an Partition .

using the following command :-

Alter table test split partition q1_post values ('CLERK', 'MANAGER') into (partition q1_post_clerk ,partition q1_post_manager)

You get the following error :-

ERROR at line 1:
ORA-14314: resulting List partition(s) must contain atleast 1 value

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.