I have a table which I partitioned (range interval partitioning) using column A , and further sub partitioned it with another column B..
I just have two partitions , each partition has 2 sub partitions, which means 4 subpartitions on whole...
while inserting into the table i get the error ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions
how to resolve this?
table definition
CREATE TABLE test
(
id number,
mydate date,
myflag varchar2(1)
) TABLESPACE xya
PARTITION BY RANGE (mydate) INTERVAL (NUMTODSINTERVAL(1,'DAY'))
SUBPARTITION BY LIST (myflag)
SUBPARTITION TEMPLATE(
SUBPARTITION p_y VALUES ('Y') TABLESPACE xya,
SUBPARTITION P_n VALUES ('N') TABLESPACE xya
)
(PARTITION first_par VALUES LESS THAN (TO_DATE('01-JAN-2014','DD-MON-YYYY')));