You can use Oracle Enterprise Manager to merge the contents of two partitions into one partition. The two original partitions are dropped, as are any corresponding local indexes. You cannot merge a hash-partitioned table or hash subpartitions of a range-hash partitioned table. If the involved partitions or subpartitions contain data, indexes may be marked UNUSABLE.
To merge partitions, follow these steps:
Navigate to the Database Home page.
On the Schema tab, click Tables or Indexes from the Database Objects section.
The Tables or Index Search page appears containing a results table listing all current tables for the current database.
Find the partitioned table or index containing the partition you want to merge and choose Edit.
Choose the Partitions tab and then select the partition you want to merge.
Choose Merge 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.