Online DDL Operations 3189 Partitioning Clause Instant In Place Permits DML Notes tables partitioned by RANGE  or  LIST . DROP PARTITION  with deletes data stored in the partition and drops the partition. However,  DROP PARTITION  with ALGORITHM=COPY or rebuilds the partitioned table and attempts to move data from the dropped partition to another partition with a compatible PARTITION ... VALUES  definition. Data that cannot be moved to another partition is deleted. DISCARD PARTITION No No No Only permits LOCK=DEFAULT IMPORT PARTITION No No No Only permits LOCK=DEFAULT TRUNCATE PARTITION No Yes Yes Does not copy existing data. It merely deletes rows; it does not alter the definition of the table itself, or of any of its partitions. COALESCE PARTITION No Yes* No LOCK={DEFAULT| SHARED| EXCLUSIVE}  is supported. REORGANIZE PARTITION No Yes* No LOCK={DEFAULT| SHARED| EXCLUSIVE}  is supported.