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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset