Hi all,
I have a table with partition on DAYNO as range partition and subpartition template as list on a column.
See the table;
CREATE TABLE TEST_TB
(dayno number(2),
ATTRI_NAME varchar(100)
)
PARTITION BY RANGE (DAYNO)
SUBPARTITION BY LIST (ATTRI_NAME)
SUBPARTITION TEMPLATE
(
SUBPARTITION PT_01 VALUES (‘ABC’),
SUBPARTITION PT_02 VALUES (‘DEF’),
SUBPARTITION PT_03 VALUES (‘GHI’),
)
( PARTITION DATA_53 VALUES (‘53’),
PARTITION DATA_54 VALUES (‘54’),
PARTITION DATA_55 VALUES (‘55’),
);
Now i added a subpartition as;
SUBPARTITION PT_04 VALUES (‘jkl’)
And try to inserts the data, it is showing error as;
ORA-14400: inserted partition key does not map to any partition.
How to solve this.
Thanking you.