You can use Oracle Enterprise Manager to redistribute the contents of a partition into two new partitions when a partition becomes too large and causes backup, recovery, or maintenance operations to take longer to complete. The high values entered for the first new partition must be within the range of the original partition. The high values of the second new partition will be the high values of the original partition.
Note: You cannot use the split funtion for hash partitions or subpartitions.
To split 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 split and choose Edit.
Choose the Partitions tab and then select the partition you want to split.
Choose Split 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.