Database VLDB and Partitioning Guide
ContentsOpens a new window
Opens a new window
Page 244 of 478

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 SubpartitionsOpens a new window".

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 PartitionsOpens a new window".

This section contains the following topics:

Previous PageOpens a new window
Page 244 of 478
Next PageOpens a new window