You can use Oracle Enterprise Manager to remove all rows from a partition of a composite-partitioned table. Truncating a partition deletes all the data from the rows of the partition but the empty partition structure remains.
You cannot truncate an index partition. However, if local indexes are defined for the table, the truncate partition function truncates the matching partition in each local index. Unless you specify Update Indexes (cannot be specified for index-organized tables), any global indexes are marked UNUSABLE and must be rebuilt.
Note: After choosing to truncate, the SQL that is generated will not execute until you choose Apply on the subsequent Table Property page.
To truncate partitions, follow these steps:
Navigate to the Database Home page.
On the Schema tab, click Tables from the Database Objects section.
The Tables Search page appears containing a results table listing all current tables for the current database.
Find the partitioned table containing the partition you want to truncate and choose Edit.
Choose the Partitions tab and then select the partition you want to truncate.
Choose Truncate from the Actions drop-down menu and press Go.
Click Help for more information about tables and partitions.
Enterprise Manager Information Roadmap
Copyright © 1996, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.