 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Oracle9i – List and
Range/List Composite Partitioning
Oracle9i continues to add partitioning functionality to the Oracle
database by providing two new partitioning algorithms, list and
range/list composite.
List Partitioning
List partitioning allows the administrator to
map a row to a specific tablespace based on the partitioning key
value. The partition is defined by specifying a hard-coded list of
individual partition key values. In Oracle9i Release 1, there was
no overflow area to hold rows that had keys that were not identified
in the list specifications. If an application program attempted to
insert a row that had a partitioning key value that did not match
any of the specifications, the row was not inserted and an Oracle
error code was returned.
Oracle9i Release 2 solves this problem by
allowing administrators to specify a default partition. Key values
that do not match the list partition specifications are placed in
the overflow tablespace. A new DEFAULT attribute has been added to
the list partition specification. The example below shows the
DEFAULT attribute being specified during partitioned table creation.
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. |
|
