Oracle Interval Partitioning Tips Oracle Database Tips by Donald BurlesonApril 31, 2015 Interval partitioning is an enhancement to range partitioning in Oracle 11g and interval partitioning automatically creates time-based partitions as new data is added. Range partitioning allows an object to be partitioned by a specified range on the partitioning key. For example, if a table was used to store