Friday, December 28, 2007

Oracle Partitioning

Oracle Partitioning allows large tables to be broken into smaller pieces that improve manageability, availability, and scalability. With partitioning you can make your database faster the larger it becomes.

Oracle support the following partitioning methods:

Range partitioning - data is mapped to partitions based on a range of column values (usually a date column)
Hash partitioning - data is mapped to partitions based on a hashing algorithm, evenly distributing data between the partitions.
List partitioning - data is mapped to partitions based on a list of discrete values.
Range-Hash partitioning - data is partitioned by range, then hashed to sub-partitions.
Range-List partitioning - data is partitioned by range, then to sub-partitions based on a value list.

Partitioning is only available with Oracle Enterprise Edition as a cost option (you need to buy licenses before you can use it).
Start the Oracle installer and check if "Oracle Partitioning" is installed. If it is, you can just start using it.
If not, you will get error ORA-00439: feature not enabled: Partitioning. If you get this error, upgrade to Enterprise Edition and/or install the partitioning option.

No comments: