Complex Partitioning in 8i
With Oracle 8i, there is only one way to implement complex partitioning: with composite range-hash partitioning (as shown below):
CREATE TABLE POS_DAY_RNG_HSH PCTFREE 10 PCTUSED 89 PARALLEL (DEGREE 10) NOLOGGING PARTITION BY RANGE (period_id) SUBPARTITION BY HASH(product_id) SUBPARTITION TEMPLATE ( SUBPARTITION sp001, SUBPARTITION sp002, SUBPARTITION sp003, SUBPARTITION sp004 ) ( PARTITION p001 VALUES LESS THAN (1073), PARTITION p002 VALUES LESS THAN (1081), PARTITION p003 VALUES LESS THAN (1089), PARTITION p004 VALUES LESS THAN (1097), PARTITION p005 VALUES LESS THAN (1105), PARTITION p006 VALUES LESS THAN (1113), PARTITION p007 VALUES LESS THAN (1121), PARTITION p008 VALUES LESS THAN (1129), PARTITION p009 VALUES ...
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.
