You can use Enterprise Manager to define the partitioning method for a table. Each partition is stored in its own segment. Each partition can be managed individually, and can operate independently of the other partitions, thus providing a structure that can be better tuned for availability and performance.
Note: The Partition tab is only available for databases with the partition option enabled.
To add a partition to a table:
Navigate to the Database Home page.
The Tables Search page appears containing a results table listing all current tables for the current database.
Click Create and select the type of table organization to specify for the new table.
After naming the table and adding at least one column, choose the Partitions sub tab to display the Partitions page.
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.