Databases Reference
In-Depth Information
SUBPARTITION INDIRECT_SALES_2000 VALUES (4,5)
TABLESPACE EXAMPLE,
SUBPARTITION OTHER_SALES_2000 VALUES (DEFAULT)
TABLESPACE EXAMPLE
),
PARTITION SALES_2000_2001_2002
VALUES LESS THAN (TO_DATE('20030101','YYYYMMDD'))
(SUBPARTITION DIRECT_SALES_2000_2001_2002 VALUES (3,9)
TABLESPACE EXAMPLE,
SUBPARTITION INDIRECT_SALES_2000_2001_2002 VALUES (4,5)
TABLESPACE EXAMPLE,
SUBPARTITION OTHER_SALES_2000_2001_2002 VALUES (DEFAULT)
TABLESPACE EXAMPLE
),
PARTITION SALES_2003
VALUES LESS THAN (TO_DATE('20040101','YYYYMMDD'))
(SUBPARTITION DIRECT_SALES_2003 VALUES (3,9)
TABLESPACE EXAMPLE,
SUBPARTITION INDIRECT_SALES_2003 VALUES (4,5)
TABLESPACE EXAMPLE,
SUBPARTITION OTHER_SALES_2003 VALUES (DEFAULT)
TABLESPACE EXAMPLE
)
);
When using composite partitioning, the subpartitions will have the corresponding physical
segments in the tablespaces, while the partition will only have a logical meaning, because
the rows of a partition will be stored in the segment of the subpartition to which they belong.
