O'Reilly logo

Oracle® DBA Guide to Data Warehousing and Star Schemas by Bert Scalzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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), ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required