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不可以
