Partition-Level Online Operation Syntax

To allow for greater data availability, alter table and truncate partition commands include the with online subclause 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.