
6.2 Partitioned Table Syntax 149
Chapter 6
PARTITION sale_to_2003 VALUES LESS THAN
(TO_DATE('2003-01-01','YYYY-MM-DD'))
TABLESPACE pdata1
, PARTITION sale_to_2004 VALUES LESS THAN
(TO_DATE('2004-01-01','YYYY-MM-DD'))
TABLESPACE pdata2
, PARTITION sale_after_2003 VALUES LESS THAN
(MAXVALUE) TABLESPACE pdata3
)
AS SELECT * FROM sale;
Let’s create a global index:
CREATE INDEX gkx1_psale_yrrev
ON psale_yrrev(industry_id) TABLESPACE indx;
Now generate statistics:
ANALYZE TABLE psale_yrrev COMPUTE STATISTICS;
CREATE TABLE: Range-List Partition
Figure 6.6 shows CREATE TABLE syntax for a range-list partition where
range partitions are subdivided into list subpartitions. ...