如题,我想让一个表有列表分区,范围分区,但是我执行sql 时候总是报错。create table t(c1 number ,c2 number)
partition by range(c1)(
partition w10 values less than(100000),
partition w20 values less than(200000),
partition w30 values less than(300000),
partition w40 values less than(400000)
)
partition by list(c2)(
partition lw10 values('100000'),
partition lw20 values('200000'),
partition lw30 values('300000'),
partition lw40 values('400000')
-- partition wmax values less than(maxvalue)
)
;
我想知道是我代码的错误,还是oracle 不允许一个表有多重类型的分区?
partition by range(c1)(
partition w10 values less than(100000),
partition w20 values less than(200000),
partition w30 values less than(300000),
partition w40 values less than(400000)
)
partition by list(c2)(
partition lw10 values('100000'),
partition lw20 values('200000'),
partition lw30 values('300000'),
partition lw40 values('400000')
-- partition wmax values less than(maxvalue)
)
;
我想知道是我代码的错误,还是oracle 不允许一个表有多重类型的分区?
可以
partition by range()
subpartition by value()