分区的问题

[treestar001]

早Oracle中分区,MAXVALUE代表什么意思.能否举例说明

[treestar001]

怎样设置MAXVALUE的值呢?

[okok999]

mark

[bigddaddy]

代表你划分区域中的最大值，例如有字段a(int)，maxvalue设为5的话，则该分区只包括a字段中5以下的数据

[「已注销」]

up

[beckhambobo]

Range Partitioning
Range partitioning maps data to partitions based on ranges of partition key values that you establish for each partition. It is the most common type of partitioning and is often used with dates. For example, you might want to partition sales data into monthly partitions.

When using range partitioning, consider the following rules:

Each partition has a VALUES LESS THAN clause, which specifies a noninclusive upper bound for the partitions. Any binary values of the partition key equal to or higher than this literal are added to the next higher partition.
All partitions, except the first, have an implicit lower bound specified by the VALUES LESS THAN clause on the previous partition.
A MAXVALUE literal can be defined for the highest partition. MAXVALUE represents a virtual infinite value that sorts higher than any other possible value for the partition key, including the null value.