Create partition Table (Interval Partitioning)

Below is the format for creating the partition table using 11gr2 new feature Interval Partitioning.


CREATE TABLE <Table_name>
 (
 Column List
)
TABLESPACE <tablespace_List>
COMPRESS FOR OLTP
PARTITION BY RANGE (ANLYS_DATE)
INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(
  PARTITION <Partition_name> VALUES LESS THAN (TO_DATE('01/02/2013','DD/MM/YYYY')) COMPRESS FOR OLTP
);