Simple Partitioning in 9i
With Oracle 9i, there are two ways to implement simple partitioning: with range partitioning (exactly the same as shown in the prior section) or with list partitioning (as shown below):
CREATE TABLE POS_DAY_LST PCTFREE 10 PCTUSED 89 PARALLEL (DEGREE 10) NOLOGGING PARTITION BY LIST (period_id) ( PARTITION p001 VALUES (1065,1066,1067,1068,1069,1070,1071,1072), PARTITION p002 VALUES (1073,1074,1075,1076,1077,1078,1079,1080), PARTITION p003 VALUES (1081,1082,1083,1084,1085,1086,1087,1088), PARTITION p004 VALUES (1089,1090,1091,1092,1093,1094,1095,1096), PARTITION p005 VALUES (1097,1098,1099,1100,1101,1102,1103,1104), PARTITION p006 VALUES (1105,1106,1107,1108,1109,1110,1111,1112), PARTITION p007 VALUES (1113,1114,1115,1116,1117,1118,1119,1120), ...
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.
