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