U0100074: GaussDB does not support level-2 partitions in interval partitions
Description
Level-2 partitions cannot be created in interval partitions on GaussDB databases.
Database Type and Version
- Source database type and version: Oracle versions supported by UGO
- Target database type and version: GaussDB versions supported by UGO
CREATE TABLE range_interval ( Prod_id NUMBER(6), time_id TIMESTAMP ) PARTITION BY RANGE (time_id) INTERVAL(numtoyminterval(2 ,'month')) SUBPARTITION BY LIST (prod_id) ( PARTITION p1 VALUES LESS THAN (to_date('2023-02-01','yyyy-mm-dd')) ( SUBPARTITION p_202301_a VALUES (1) ), PARTITION p2 VALUES LESS THAN (to_date('2023-03-01','yyyy-mm-dd')) ( SUBPARTITION p_202303_a VALUES (3) ) );
Suggestion
No solution is available. You are advised to refactor application code or perform the following operations:
1. Add subpartitions to tables using composite level-2 partitioning strategies supported by GaussDB, such as range-range, range-hash, and hash-list by following GaussDB documentation.
2. Modify or remove subpartitions, so that level-2 partitions will not be created in the interval 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