My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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
  Cause
  Solution
  References

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