oracle复合分区创建,关于oracle复合分区的组合

只是技术实现上的限制，新版本支持的组合越来越多。

http://www.oracle.com/technetwor ... -wp-12c-1896137.pdf

Partitioning Functionality at a Glance

The following table shows all available basic partitioning methods in Oracle Database 12c:

BASIC PARTITIONING METHODS IN ORACLE DATABASE 12C

Partitioning Strategy Data Distribution Sample Business Case

Range Partitioning Consecutive ranges of values. Orders table range partitioned by order_date

List Partitioning Unordered lists of values. Orders table list partitioned by country

Hash Partitioning Internal hash algorithm Orders table hash partitioned by customer_id

Composite Partitioning

• Range-Range

• Range-List

• Range-Hash

• List-List

• List-Range

• List-Hash

• Hash-Hash

• Hash-List

• Hash-Range

Combination of two of the

above-mentioned basic

techniques of Range, List, and

Hash

Orders table is range partitioned by order_date and

sub-partitioned by hash on customer_id

Orders table is range partitioned by order_date and

sub-partitioned by range on shipment_date

Orders table is list partitioned by country and subpartitioned

by range on order_date

Orders table is list partitioned by country and subpartitioned

by hash on customer_id

The basic partitioning methods can be used in conjunction with the following partitioning extensions. All

combinations of partition extensions, e.g Interval-Reference, are supported for heap organized tables.

PARTITIONING EXTENSIONS IN ORACLE DATABASE 12C

Partitioning Extension Description Sample Business Case

Interval Partitioning Extension to Range Partition. Defined by an Orders table partitioned by order_date

interval, providing equi-width ranges. With with a predefined daily interval, starting • Interval

the exception of the first partition all with '01-Jan-2013' • Interval-Range partitions are automatically created on-

• Interval-List demand when matching data arrives.

• Interval-Hash

Reference Partitioning Partitioning for a child table is inherited from (Parent) Orders table range partitioned

the parent table through a primary key – by order_date and inherits the

foreign key relationship. The partitioning partitioning technique to (child) order

keys are not stored in actual columns in the lines table. Column order_date is only

child table. present in the parent orders table

Virtual column based Defined by any partition techniques where Orders table has a virtual column that

Partitioning the partitioning key is based on a virtual derives the sales region based on the

column. Virtual columns are not stored on first three digits of the customer

disk and only exist as metadata. account number. The orders table is

then list partitioned by sales region.