Chapter 46
Partition and Conquer
Raj Pande
With Oracle8, the lowest level of granularity for data storage has been lowered from tables to partitions. A table can have many partitions, each with the same logical attributes, but with different physical attributes. The concept of partitioning opens up new possibilities in terms of tuning and database administration. However, at least in the current release, partitioning comes with a lot of constraints that the DBA must be aware of. Partitions cannot be used, for example, with tables that use the object extension of Oracle8.
This chapter builds on a basic understanding of the partitioning concept and provides detailed examples.
Conceptual Terms
- Partitioning keys. The list of columns that are ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
