Any other value for state code, such as MI, will end up in the other_states partition in
tablespace PRD03.
Using Composite Range-Hash Partitioning As the name implies, range-hash partitioning uses
range partitioning to divide rows first using the range method and then subpartitioning the rows
within each range using a hash method. Composite range-hash partitioning is good for historical
data with the added benefit of increased manageability and data placement within a larger
number of total partitions.
?–
?–
?–
562 Oracle Database 11g DBA Handbook
To use composite range-hash partitioning, you must specify the following criteria:
Primary partitioning method (range)
Range partitioning column(s)
Partition names identifying the bounds of the partition
Subpartitioning method (hash)
Subpartitioning column(s)
Number of subpartitions for each partition or subpartition name
In the following example, you will track house and garden tool rentals. Each tool is identified
by a unique tool number; at any given time, only about 400 tools are available for rental, although
there may be slightly more than 400 on a temporary basis. For each partition, we want to use
hash partitioning for each of eight subpartitions, using the tool name in the hashing algorithm.
The subpartitions will be spread out over four tablespaces: PRD01, PRD02, PRD03, and PRD04.
Here is the create table command to create the range-hash partitioned table:
create table oe.
Pages:
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841