Interval partitioning is a partitioning method introduced in Oracle 11g. This is a helpful addition to range partitioning where Oracle automatically creates a partition when the inserted value exceeds all other partition ranges. The following restrictions apply: You can only specify one partitioning key column, and it must be of NUMBER or DATE type. Interval partitioning is NOT supported for index