Range partitions in the Oracle Partition Table

RangePartition:

RangeA partition is a table partition with a wide range of applications. It uses the range of column values as a partition condition to store records to column values.RangePartition.

For example, by time,2010Year1Monthly dataAPartition,2Monthly dataBPartition: when creating a partition, you must specify the Column Based on and the partition range value.When partitioning by time,If some records cannot predict the range, you can createMaxvaluePartition, all records not within the specified range will be storedMaxvalueIn the partition.

 

For example:

Create table pdba (id number, time date) partition by range (time)

(

Partition p1 values less than (to_date ('1970-10-1 ', 'yyyy-mm-dd ')),

Partition p2 values less than (to_date ('1970-11-1 ', 'yyyy-mm-dd ')),

Partition p3 values less than (to_date ('2017-12-1 ', 'yyyy-mm-dd ')),

Partition p4 values less than (maxvalue)

)