i want create table partition hash on 1 column , subpartition list on column. table creation should below:
create table testt ( id char(3), time date, month (extract (month time)) ) partition hash (id) partitions 4 store in (ts1, ts2, ts3, ts4) subpartition list (month) subpartition template ( subpartition january values (01), subpartition february values (02), ... ) i need maintain partition hash legacy reasons. can change subpartition range/hash. oracle not letting me create partition hash + subpartition list/range/hash. searched lot didn't 1 example. wondering if supported or not. can please let me know how it?
your statement has invalid syntax, see http://docs.oracle.com/database/121/sqlrf/statements_7002.htm#cjabbbai.
the specification of hash partition count , tablespaces should after subpartition templates.
create table testt ( id char(3), time date, month (extract (month time)) ) partition hash (id) subpartition list (month) subpartition template ( subpartition january values (01), subpartition february values (02), ... ) partitions 4 store in (ts1, ts2, ts3, ts4) 