如何在oracle中创建子分区？

Question

现在我开始学习oracle.some中的分区概念了。我现在如何管理分区，我试图在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) 
    )) ; 

的感谢！

Answer 1

有两个错误 - 缺少逗号和你都提到MAXVALUE为maxvalues

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(maxvalue)(
    subpartition sp5 values(default) 
    )) ; 

Answer 2

错误的子分区/分区定义之间的逗号。