partition_clause
The following is the syntax for the partition_clause in the CREATE TABLE statement:
PARTITION BY RANGE (column_list) ( PARTITION [partition_name] VALUES LESS THAN (value_list) [segment_attrib_clause] )
- PARTITION BY RANGE
Specifies the columns (in the column_list) used to partition the table.
- PARTITION
Specifies the partition name.
- VALUES LESS THAN
Specifies the values that all rows in the partition must be less than. Specify the keyword MAXVALUE to indicate that there is no maximum value.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
