create table student_reistry
(student_id number,
last_name varchar2(20),
regsty_date date,
qq varchar2(20))
partition by range (regsty_date)
(partition p2001 values less than (to_date('2002-01-01','yyyy-mm-dd')),
partition p2002 values less than (to_date('2003-01-01','yyyy-mm-dd')),
partition p2003 values less than (to_date('2004-01-01','yyyy-mm-dd')),
partition p2004 values less than (to_date('2005-01-01','yyyy-mm-dd')),
partition pmax values less than (maxvalue)
);