Adding a Partition to a List Partitioned Table
You can run ALTER TABLE ADD PARTITION to add a partition to a list partitioned table. The enumerated values of the new partition cannot be the same as those of any existing partition.
ALTER TABLE list_sales ADD PARTITION channel5 VALUES ('X') TABLESPACE tb1;
If a list partitioned table has the DEFAULT partition, partitions cannot be added. You can run the ALTER TABLE SPLIT PARTITION command to split partitions.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot