oracle 手动添加分区,如何在oracle中创建子分区？

现在我开始学习oracle.some中的分区概念了。我现在如何管理分区，我试图在Oracle中创建子分区。我得到这个错误如何在oracle中创建子分区？

SQL Error: ORA-14160: this physical attribute may not be specified for a table subpartition

14160. 00000 - "this physical attribute may not be specified for a table subpartition"

*Cause: unexpected option was encountered while parsing physical

attributes of a table subpartition; TABLESPACE is the only valid

option

*Action: remove invalid option(s)

*Comment: this error could have resulted from omission of a

terminating (right) parenthesis following the list of

subpartition descriptions

相应的代码是：提前

create table sub_pat_test(emp_name varchar2(30),job_id varchar2(30),hire_date date)

partition by range(hire_date) subpartition by list(job_id)(

partition p1 values less than(to_date('01-01-2003','dd-mm-yyyy'))(

subpartition sp1 values('HR_REP','PU_MAN'),subpartition sp11 values(default)),

partition p2 values less than(to_date('01-01-2004','dd-mm-yyyy'))(

subpartition sp2 values('AC_ACCOUNT','FI_ACCOUNT')

subpartition sp22 values(default)

)

partition p3 values less than(to_date('01-01-2005','dd-mm-yyyy'))(

subpartition sp3 values('SH_CLERK','ST_CLERK')

subpartition sp33 values(default)

))

partition p4 values less than(to_date('01-01-2006','dd-mm-yyyy'))(

subpartition sp4 values('SA_MAN','PU_MAN')

subpartition sp44 values(default)

)

partition p5 values less than(maxvalues)(

subpartition sp5 values(default)

)) ;

的感谢！