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.
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.