Complex Partitioning in 9i
With Oracle 9i, there are now two ways to implement complex partitioning: with composite range-hash partitioning (exactly the same as shown in the previous section) and composite range-list partitioning (as shown below). Note that we had to add the TIME–ZONE column (denoted in bold) to the primary key to sub-partition by it. Oracle requires the sub-partition criteria to be part of the primary key or unique index for the table.
CREATE TABLE POS_DAY_RNG_LST PCTFREE 10 PCTUSED 89 PARALLEL (DEGREE 10) NOLOGGING PARTITION BY RANGE (period_id) SUBPARTITION BY LIST(time_zone) SUBPARTITION TEMPLATE ( SUBPARTITION east VALUES ('EST'), SUBPARTITION central VALUES ('CST'), SUBPARTITION mountain VALUES ('MST'), SUBPARTITION west ...Get Oracle® DBA Guide to Data Warehousing and Star Schemas now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
