Partition-Level Online Operation Syntax

To allow for greater data availability, alter table and truncate partition commands include the with online sub-clause in the partition clause.

Partition locking must first be enabled.

The syntax for alter table is:

alter table table_name    
{merge | drop | move | split} partition partition_name     
existing_clause   
with online

where:

table_name – is the name of the table to modify.

partition_name – specifies the name of the partition to merge, drop, move, or split.

existing_clause – is the partition subclause, depending on the partition action specified.

with online – executes in an online mode. Enables concurrent access to the table.

The syntax for truncate partition is:

truncate table table_name            
   [partition partition_name]           
   [with online]

where:

table_name – is the name of the table to truncate.

partition_name – specifies the name of the partition to truncate.

with online – executes in an online mode. Enables concurrent access to the table.