Partitioning addresses key issues in supporting very large tables and indexes by letting you decompose them into smaller and more manageable pieces called partitions. Each partition of a table must have the same logical attributes, such as column names, datatypes, and constraints, but each partition can have separate physical attributes such as pctfree, pctused, and tablespaces.
Partitioning enables data management operations such data loads, index creation and rebuilding, and backup/recovery at the partition level, rather than on the entire table. This results in significantly reduced times for these operations. Partitioning improves query performance. In many cases, the results of a query can be achieved by accessing a subset of partitions, rather than the entire table.
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.
To add a partition to an index:
Navigate to the Database Home page.
On the Schema tab, click Indexes from the Database Objects section.
The Indexes Search page appears containing a results table listing all current indexes for the current database.
Click Create.
After naming the index, choose the Partitions sub tab to display the Partitions page.
Click Help for more information about indexes and partitions.
Related Topics
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.