Example On How to Quickly Perform a SPLIT PARTITION Using FAST SPLIT
Last updated on JANUARY 18, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
To split an existing partition of a partitioned table, the command to use is:
This will split the partition into two new partitions called newpartition1 and newpartition2 with the split occuring at the partition key value. All rows with a partition key value less than value will be moved to newpartition1, and the remaining rows of the partition will be moved to newpartition2.
Note that all rows will be moved from the original partition to one of the new partitions. This means that:
- The operation may require a long time to complete.
- Table / partition locks may be held for a long time.
- Global indexes will be invalidated and need to be rebuilt.
It may not be possible to keep such a table locked for an extended period of time or to rebuild many global indexes.
It is often possible to avoid long running split operations and index rebuilding with the method known as fast split.
Fast Split can be used with some knowledge of how the database decides to make use of this method and plan the split accordingly.
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