分区，错误何在，pl/sql 在list下划了个红线
create   table   tt1
(
  id   number(3),
  name   varchar2(20),
  sex   varchar2(4),
  age   number(3)
)
partition   by   range   (age)   subpartition   by   list(sex)
(
  partition   trans_p1   values   less   than   (10)   tablespace   tbs1
  (
    subpartition   p1_subp1   values( 'boy '),
    subpartition   p1_subp2   values( 'girl ')
  ),
  partition   trans_p2   values   less   than   (20)   tablespace   user_data
  (
    subpartition   p2_subp1   values( 'boy '),
    subpartition   p2_subp2   values( 'girl ')
  )
)

ORA-14151:   无效的表分区方法

------解决方案--------------------
Invalid partitioning method was specified in CREATE TABLE statement. A table may be partitioned by RANGE, HASH, or composite range/hash (R+H).

不过语句本身语法正确,我都执行通过了建好了table.
------解决方案--------------------
好像是range+list不可以