A convenient new feature introduced in Oracle 11g is interval-based partitioning.  One simply has to create a single starting partition and specify the interval for partitions above that transition point.  As data is added to the table, Oracle will automatically create new partitions as needed.  For example, consider the following table:

Comment