How to Perform a FAST SPLIT PARTITION Using ALTER TABLE? (Doc ID 1268714.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Goal

The Article:   [ID 378138.1] states:

According to the documentation:

"Fast split partitioning takes advantage of those situations in which a split partition results in all rows being moved to a single partition. If all the rows map into a single
partition and if the segment attributes of the old partition and the segment attributes of the partition inheriting all the rows match, then the database simply reuses the old
segment and adds an empty segment for the other partition. Another benefit of this is that global indexes do not have to be invalidated and, in certain cases, local index
partitions corresponding to the new partitions are also usable."

Thus, the new partitions should have the same storage configuration as the original partition.

This last statement has been the reason for the worked example below.



Solution

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