About Truncating a Table Partition

Use the ALTER TABLE TRUNCATE PARTITION statement to remove all rows from a table partition, with or without reclaiming space. Truncating a partition in an interval-partitioned table does not move the transition point. You can truncate partitions and subpartitions in a reference-partitioned table.

• Truncating Table Partitions Containing Data and Global Indexes

• Truncating a Partition Containing Data and Referential Integrity Constraints