Oracle Partition - Split

About

Syntax

alter table tableName

_

where:

  • AT Clause: The AT clause applies only to range partitions.
  • VALUES Clause: The VALUES clause applies only to list partitions.
  • The INTO clause lets you describe the two partitions resulting from the split.
    • In partition_spec, the keyword PARTITION is required even if you do not specify the optional names and physical attributes of the two partitions resulting from the split. If you do not specify new partition names, then Oracle Database assigns names of the form SYS_Pn. Any attributes you do not specify are inherited from current_partition.

AT

Specify the new noninclusive (LESS THAN) upper bound for the first of the two new partitions.

Example:

alter table tableName split partition partitionName 
at ( to_date( '02-01-2000', 'mm-dd-yyyy' ) ) 
into ( newPartitionNameBelow, newPartitionNameAbove );

VALUES

  • Specify the partition values you want to include in the first of the two new partitions. Oracle Database creates the first new partition using the partition value list you specify and creates the second new partition using the remaining partition values from current_partition. Therefore, the value list cannot contain all of the partition values of current_partition, nor can it contain any partition values that do not already exist for current_partition.

Documentation / Reference


Powered by ComboStrap