About Truncating Partitions and Subpartitions

Use the ALTER TABLE TRUNCATE PARTITION statement to remove all rows from a table partition. Truncating a partition is similar to dropping a partition, except that the partition is emptied of its data, but not physically dropped. For information about dropping a partition, refer to "About Dropping Partitions and Subpartitions".

You cannot truncate an index partition. However, if local indexes are defined for the table, the ALTER TABLE TRUNCATE PARTITION statement truncates the matching partition in each local index. Unless you specify UPDATE INDEXES, any global indexes are marked UNUSABLE and must be rebuilt. (You cannot use UPDATE INDEXES for index-organized tables. Use UPDATE GLOBAL INDEXES instead.)

For information about asynchronous index maintenance for truncating partitions, refer to "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions".

This section contains the following topics:

• About Truncating a Table Partition

• Truncating a Subpartition

• Truncating a Partition with the Cascade Option

• Truncating Multiple Partitions