Updated on 2025-06-07 GMT+08:00

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
Syntax Example
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.