Oracle Partition

CREATE TABLE table2000 (
x number,
y number,
z DATE
) tablespace DATA4
PARTITION BY RANGE (z)
(
PARTITION tab_1999_h1 VALUES LESS THAN(to_date('30-jun-1999','dd-mon-yyyy')),
PARTITION tab_1999_h2 VALUES LESS THAN(to_date('31-dec-1999','dd-mon-yyyy')),
PARTITION tab_2000_h1 VALUES LESS THAN(to_date('30-jun-2000','dd-mon-yyyy')),
PARTITION tab_2000_h2 VALUES LESS THAN(to_date('31-dec-2000','dd-mon-yyyy'))
)
/

CREATE TABLE AA_GENERAL_ATTENDANCE
(GL_MARKS_MONTH NUMBER (4),
GL_BATCH VARCHAR2(4),
GL_JIB VARCHAR2(1),
... ... ... ... GLR_OVER_UNDER_IND VARCHAR2(1))
PCTFREE 0 PCTUSED 40 INITRANS 1
STORAGE(INITIAL 250M NEXT 10M MINEXTENTS 1
MAXEXTENTS 1000 PCTINCREASE 0 )
PARTITION BY RANGE (GL_MARKS_MONTH)
(PARTITION SSTN7912 VALUES LESS THAN (8000)
TABLESPACE SSTN 7912
STORAGE (INITIAL 100M NEXT 10M PCTINCREASE 0)
, PARTITION SSTN 8012 VALUES LESS THAN (8100)
TABLESPACE SSTN 8012,
PARTITION SSTN 8112 VALUES LESS THAN (8200)
TABLESPACE SSTN 8112,
PARTITION SSTN 8212 VALUES LESS THAN (8300)
TABLESPACE SSTN 8212,
... ... ... ...
PARTITION SSTN 9712 VALUES LESS THAN (9800)
TABLESPACE SSTN 9712,
PARTITION SSTN 9801 VALUES LESS THAN (MAXVALUE)
TABLESPACE SSTN 9801
STORAGE (INITIAL 50M NEXT 5M PCTINCREASE 0)
);