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
PARTITION statement truncates the matching partition in each local index. Unless you specify
INDEXES, any global indexes are marked
UNUSABLE and must be rebuilt. (You cannot use
INDEXES for index-organized tables. Use
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: