创建分区表

create table empr(empno number(4) primary key,ename varchar2(10),job varchar2(9),mgr number(4),hiredate date,sal number(7,2),comm number(7,2),deptno number(2)) partition by range(hiredate) (partition empr_p1 values less than(to_date('1981-01-01','yyyy-mm-dd')) tablespace d1,partition empr_p2 values less than(to_date('1982-01-01','yyyy-mm-dd')) tablespace d2,partition empr_p3 values less than(to_date('1983-01-01','yyyy-mm-dd')) tablespace d3,partition empr_p4 values less than(to_date('1983-01-01','yyyy-mm-dd')) tablespace d4,partition empr_p5 values less than(maxvalue) tablespace d5);