TRUNCATE PARTITION

You can run this command to quickly clear data in a partition. The function is similar to that of DROP PARTITION. The difference is that TRUNCATE PARTITION deletes only data in a partition, and the definition and physical files of the partition are retained. You can clear a partition by specifying the partition name or partition value.

Running this command will invalidate the global index. You can use the UPDATE GLOBAL INDEX clause to update the global index synchronously or rebuild the global index.

• Clearing Partitions from a Partitioned Table
  
• Clearing Partitions from a Level-2 Partitioned Table
  
• Clearing Level-2 Partitions from a Level-2 Partitioned Table