All About Table & Index Local and Global Partitioning
CREATE TABLE TBL_TXN ( USER_ID VARCHAR2(15 BYTE) NOT NULL, TRANS_DATE DATE NOT NULL, SERVICE_TYPE NUMBER NOT NULL ) PARTITION BY RANGE (TRANS_DATE) SUBPARTITION BY LIST(SERVICE_TYPE) SUBPARTITION TEMPLATE( SUBPARTITION type1 VALUES (1) TABLESPACE USERS, SUBPARTITION type2 VALUES (2) TABLESPACE USERS, SUBPARTITION type3 VALUES (3) TABLESPACE USERS) (PARTITION TXN_010311 VALUES LESS THAN (TO_DATE(' 2011-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE USERS, PARTITION TXN_020311 VALUES LESS THAN (TO_DATE(' 2011-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE USERS, PARTITION TXN_030311 VALUES LESS THAN (TO_DATE(' 2011-03-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE USERS ) alter table TBL_TXN add partition TXN_040311 VALUES LESS THAN (TO_DATE(' 2011-03-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', &