 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Range/List Composite
Partitioning
CREATE TABLE sales
(salesid NUMBER(9999), transdate DATE, state VARCHAR2(30)…..)
PARTITION BY RANGE (transdate)
SUBPARTITION BY LIST (state)
SUBPARTITION TEMPLATE
(PARTITION region_north VALUES (‘New York’, ‘Maine’)
PARTITION region_south VALUES (‘Florida’, ‘Georgia’))
(PARTITION 2002_quarter1 values less than
(TO_DATE (’01-APR-2002’, ‘DD-MON-YYYY’)),
PARTITION 2002_quarter2 values less than……..
The CREATE TABLE partitioned tablespace above
uses the SUBPARTITION TEMPLATE clause to define the subpartitions.
If all subpartitions have the same definition, administrators are
able to code the subpartition specification once and Oracle will
apply the template specification to each main partition that does
not override the template with its own subpartition specification.
If the template were not used, the subpartition clause would have to
be specified after each main partition specification.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
