No results found

Your search did not match any results.

We suggest you try the following to help find what you're looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.


Trending Questions

Oracle  Partitioning

Oracle Partitioning

Oracle Partitioning enhances the manageability, performance, and availability of large databases.

Oracle Partitioning

Partitioning Overview

Partitioning is powerful functionality that allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Oracle provides a comprehensive range of partitioning schemes to address every business requirement. Moreover, since it is entirely transparent in SQL statements, partitioning can be used with any application, from packaged OLTP applications to data warehouses

Key Benefits


  • Increases performance by only working on the data that is relevant.
  • Improves availability through individual partition manageability.
  • Decreases costs by storing data in the most appropriate manner.
  • Is easy as to implement as it requires no changes to applications and queries.
  • Is a mature, well proven feature used by thousands of Oracle customers

Partitioning Methods

Oracle supports a wide array of partitioning methods:

  • Range Partitioning The data is distributed based on a range of values.
  • List Partitioning The data distribution is defined by a discrete list of values. One or multiple columns can be used as partition key.
  • Auto-List Partitioning Extends the capabilities of the list method by automatically defining new partitions for any new partition key values.
  • Hash Partitioning An internal hash algorithm is applied to the partitioning key to determine the partition.
  • Composite Partitioning Combinations of two data distribution methods are used. First, the table is partitioned by data distribution method one and then each partition is further subdivided into subpartitions using the second data distribution method.
  • Multi-Column Range Partitioning An option for when the partitioning key is composed of several columns and subsequent columns define a higher level of granularity than the preceding ones.
  • Interval Partitioning Extends the capabilites of the range method by automatically defining equi-partitioned ranges for any future partitions using an interval definition as part of the table metadata.
  • Reference Partitioning Partitions a table by leveraging an existing parent-child relationship. The primary key relationship is used to inherit the partitioning strategy of the parent table to its child table.
  • Virtual Column Based Partitioning Allows the partitioning key to be an expression, using one or more existing columns of a table, and storing the expression as metadata only.
  • Interval Reference Partitioning An extension to reference partitioning that allows the use of interval partitioned tables as parent tables for reference partitioning.
  • Range Partitioned Hash Cluster Allows hash clusters to be partitioned by ranges.

Partitioning Documentation

Oracle Partitioning is an option for Oracle Database 12c Enterprise Edition that enables large tables and indexes to be subdivided into smaller pieces, improving performance, manageability, and availability for tens of thousands of applications. Documentation specific to Oracle Partitioning, including partitioning concepts, partitioning for availability, manageability and performance, and partition administration, is available here in the Database VLDB and Partitioning Guide. Documentation of the full capabilities of Oracle Database 12c can also be found here.

Learn more about Oracle Partitioning by exploring data sheets, presentations, online tutorials, demos, and more!