PARTITION SPLIT FAILS WTH ORA-04000 (Doc ID 1068174.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.0 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

On 11.2. version, Data Warehousing production

When attempting to split partition of a table stored in ASSM tablespace, the following error occurs:

ERROR
-----------------------
SQL> alter table t split partition p1000 at (3) into (partition p2, partition p1000);

ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

Table was created this way and the partition was added this way:

SQL> -- Create table works because we are on ASSM
SQL> create table t (a number, b number) pctfree 80 partition by range (a) ( partition p1 values less than (2) );

Table created
SQL> -- Partition add works
SQL> alter table t add partition p1000 values less than (1000);

Table altered

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms