OracleBrains.Com header image 2

Interval Partitioning: A new partitioning strategy in Oracle Database 11g

July 13th, 2007 by Rajender Singh · 1 Comment

One more features which really look interesting and I will be looking forward to implement it is, A new partitioning strategy in Oracle Database 11g, Interval partitioning extends the capabilities of the range method to define equipartitioned ranges using an interval definition. Rather than specifying individual ranges explicitly, Oracle will create any partition automatically as-needed whenever data for a partition is inserted for the very first time. Interval partitioning greatly improves the manageability of a partitioned table.

For example:

An interval partitioned table could be defined so that Oracle creates a new partition for every month in a calendar year; a partition is then automatically created for new month as soon as the first record for that month is inserted into the database.


Tags: Oracle 11g New Features

1 response so far ↓

  • 1 bill // Dec 2, 2007 at 10:23 pm

    great examples! oh, wait, you don’t give any examples.

Leave a Comment