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: 无效的表分区方法
(
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: 无效的表分区方法
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货