Partitioning Tables  «Prev 

Enabling row movement

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

CREATE TABLE tablename physical storage clause 
CREATE TABLE WHOLESALE_ORDER
(ORDER_ID NUMBER,
CUST_ID NUMBER,
LAST_PART_ORDERED NUMBER,
ORDER_DATE DATE)
TABLESPACE USERS PCTFREE 20
PARTITION BY RANGE (LAST_PART_ORDERED)
(PARTITION LOW_PART VALUES LESS THAN (1000),
PARTITION MED_PART VALUES LESS THAN (50000),
PARTITION HIGH_PART VALUES LESS THAN (MAXVALUE))
ENABLE ROW MOVEMENT

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