Hi ,
I am trying to create a table which will have a yearly partition and monthly subpartition. Below script is used to create the table.
CREATE TABLE "MESODS"."WORK_ORDER_PART_PILOT"
(
"ORDER_KEY" NUMBER(19,0) NOT NULL ENABLE,
"CREATION_TIME" TIMESTAMP (3) NOT NULL ENABLE
)
PARTITION BY RANGE (EXTRACT(YEAR FROM CREATION_TIME))
(
PARTITION p_2009 VALUES LESS THAN (2010)
SUBPARTITION BY RANGE (EXTRACT(MONTH FROM CREATION_TIME)) (
SUBPARTITION sp_jan VALUES LESS THAN (2),
SUBPARTITION sp_feb VALUES LESS THAN (3),
SUBPARTITION sp_mar VALUES LESS THAN (4),
SUBPARTITION sp_apr VALUES LESS THAN (5),
SUBPARTITION sp_may VALUES LESS THAN (6),
SUBPARTITION sp_jun VALUES LESS THAN (7),
SUBPARTITION sp_jul VALUES LESS THAN (8),
SUBPARTITION sp_aug VALUES LESS THAN (9),
SUBPARTITION sp_sep VALUES LESS THAN (10),
SUBPARTITION sp_oct VALUES LESS THAN (11),
SUBPARTITION sp_nov VALUES LESS THAN (12),
SUBPARTITION sp_dec VALUES LESS THAN (13)
)
);
but this fails with Missing Paranthesis error ORA-00907 .
Please guide me to fix this ussue