4 Partition Administration

Partition administration is an important task when working with partitioned tables and indexes.

This chapter describes various aspects of creating and maintaining partitioned tables and indexes.

This chapter contains the following sections:

• Specifying Partitioning When Creating Tables and Indexes

• Specifying Composite Partitioning When Creating Tables

• Maintenance Operations Supported on Partitions

• Maintenance Operations for Partitioned Tables and Indexes

• About Dropping Partitioned Tables

• Changing a Nonpartitioned Table into a Partitioned Table

• Viewing Information About Partitioned Tables and Indexes

Note:

Before you attempt to create a partitioned table or index, or perform maintenance operations on any partitioned table, it is recommended that you review the information in Partitioning Concepts.

See Also:

Oracle Database SQL Language Reference for general restrictions on partitioning, the exact syntax of the partitioning clauses for creating and altering partitioned tables and indexes, any restrictions on their use, and specific privileges required for creating and altering tables