Author: techfox9
Oracle create table with partitioning ..
Tuesday, June 9th, 2009 @ 9:51 am
Example of range partitioning:
CREATE TABLE sales (year NUMBER(4),
product VARCHAR2(10),
amt NUMBER(10,2))
PARTITION BY RANGE (year)
PARTITION p1 VALUES LESS THAN (1992) TABLESPACE u1,
PARTITION p2 VALUES LESS THAN (1993) TABLESPACE u2,
PARTITION p3 VALUES LESS THAN (1994) TABLESPACE u3,
PARTITION p4 VALUES LESS THAN (1995) TABLESPACE u4,
PARTITION p5 VALUES LESS THAN (MAXVALUE) TABLESPACE u5;
http://www.oracle-dba-online.com/sql/oracle_table_partition.htm
