
February 28th, 2005, 07:47 AM
|
|
|
|
partitioning context does this look right?
Code:
create Table students (
student_no NUMBER(8) CONSTRAINT pk_student_no Primary Key,
firstname Varchar2(15),
lastname Varchar(20),
streetno Varchar2(30),
city varchar2(20),
postcode varchar2(9),
phone varchar2(15),
userid char(5),
enrolment_date date,
enrolment_year number(4))
partition by range (enrolment_year)
(partition S1 values less than (2001) tablespace comp3_5 Storage (initial 1K Next 1K)
partition S2 values less than (2002) tablespace comp3_5 Storage (initial 1K Next 1K pctincrease0)
partition S3 values less than (2003) tablespace comp3_5 Storage (initial 1K Next 1K pctincrease0)
partition S4 values less than (2004) tablespace comp3_5 Storage (initial 2K Next 1K pctincrease0)
partition S5 Maxvalue tablespace comp3_5 Storage (initial 3K Next 1K pctincrease0));
or should each partition have its own opening/closing brackets?
|