Partitioning Tables  «Prev 

Enabling row movement

CREATE TABLE tablename
(column1 datatype,
column2 ...,
physical storage clauses
PARTITION BY RANGE (column list)
(PARTITION partname1 VALUES LESS THAN (values list),
PARTITION partname2 ...)
CREATE TABLE tablename physical storage clause

Location 1 Include optional storage clauses here such as TABLESPACE, PCTFREE, and PCTUSED.
Location 2 Define the partitions here.
Location 3 To allow row movement, add this clause to the end of the statement. The default is no row movement.