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.