Oracle Partition - Range Composite (With Sub-partitions)

About

A range partitioning scheme with Sub-partitions.

Articles Related

Syntax

composite_range_partitions (ie with subpartitions)

The syntax follow:

• the standard range scheme
• the range interval scheme
• and add the sub-partition clause:

Example

• Oracle Partition - Range/List (Partition by Range, Sub-partition by List)