11g Feature: Interval Partitioning Example (Doc ID 466352.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Goal

Interval Partitioning

This new partitioning strategy fully automates the partition creation for range. In other words, new partitions will be created when they are needed. By defining the interval criteria, the database knows when to create new partitions for new or modified data. Managing the creation of new partitions can be a cumbersome and highly repetitive task. This is especially true for predictable additions of partitions covering small ranges, such as adding new daily partitions. Interval partitioning automates this operation by creating partitions on-demand.

You should consider the following:

• You can only specify one partitioning key column, and it must be of NUMBER or DATE type.
• Interval partitioning is not supported for Index Organized tables.
• You cannot create a domain
  
  

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.