Partitioning Overview

Partitioning allows a table, index, or index-organized table to be subdivided into smaller pieces, where each piece of such a database object is called a partition. Each partition has its own name, and may optionally have its own storage characteristics.

This section contains the following topics:

• Basics of Partitioning

• Partitioning Key

• Partitioned Tables

• Partitioned Index-Organized Tables

• System Partitioning

• Partitioning for Information Lifecycle Management

• Range Partitioning for Hash Clusters

• Partitioning and LOB Data

• Collections in XMLType and Object Data