Hi,
I have list-list partitioned table. I was able to add a new partition, but unable to add sub-partitions under it.
My existing partions store values like 2008,2009....
And sub-partitions store values like NULL, Other...
There are same set of sub-partitions that hold same value under each partition.
2008
NULL
Other
-
-
2009
NULL
Other
-
-
in that order.
How to add same set of new sub-partitions under new partition I have created?
ALTER TABLE TRANSACTION ADD PARTITION "TRANS_2007" VALUES (2007) TABLESPACE "SAT";
table TRANSACTION altered.
ALTER TABLE TRANSACTION MODIFY PARTITION "TRANS_2007" ADD SUBPARTITION "TRANS_NULL_2007" VALUES (NULL) TABLESPACE "NULL";
Error starting at line 31 in command:
ALTER TABLE TRANSACTION MODIFY PARTITION "TRANS_2007" ADD SUBPARTITION "TRANS_NULL_2007" VALUES (NULL) TABLESPACE "NULL"
Error report:
SQL Error: ORA-14622: Value NULL already exists in subpartition 1
14622. 00000 - "Value %s already exists in subpartition %s"
*Cause: One of the list values in the ADD SUBPARTITION or ADD VALUES
statement already exists in another subpartition
*Action: Remove the duplicate value from the statement and try again
Regards,
Sam