subpartition list Oracle 12.2.0.1
Hello,
I would like to use automatic list partition but it seems it does not work for subpartition list.
is my syntax correct?
Thanks for your help
CREATE orders (
order_id NUMBER (12),
order_date DATE CONSTRAINT order_date_nn NOT NULL,
state VARCHAR2(2),
flag CHAR(1),
ind CHAR(1)
)
PARTITION BY RANGE (order_date) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
SUBPARTITION BY LIST (state,flag, ind) AUTOMATIC
SUBPARTITION TEMPLATE
( SUBPARTITION order_d1 VALUES ('AA', 'Y', '1'),
SUBPARTITION order_d2 VALUES (('BB', 'N','3'),('CC', 'Y','3')))
(PARTITION order_p1 VALUES LESS THAN (TO_DATE ('01-DEC-2015','DD-MON-YYYY')))