Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from Oracle to GaussDB/ U0100062: The target database does not support the INTERVAL clause in range partitioning
Updated on 2026-03-19 GMT+08:00
View PDF
Share

U0100062: The target database does not support the INTERVAL clause in range partitioning

Description

GaussDB Distributed does not support the INTERVAL clause in range partitioning.

Database Type and Version

  • Source database type and version: Oracle versions supported by UGO
  • Target database type and version: GaussDB Distributed versions supported by UGO

Syntax Example

 CREATE TABLE CD_JOB_T6 (    JOB_ID NUMBER NOT NULL ENABLE,
      BATCH_DATE DATE,
      PROJECT_ID NUMBER,
      SUB_PROJECT_ID NUMBER,
      CONSTRAINT pk_CD_JOB_T6      PRIMARY KEY (JOB_ID),
      CONSTRAINT uq_CD_JOB_T6      UNIQUE (PARENT_JOB_ID,
 PAIRED_TABLE_ID) )
 PARTITION BY RANGE (BATCH_DATE) INTERVAL (NUMTODSINTERVAL(1,
'DAY'))
( PARTITION PART_0_2014    VALUES LESS THAN (TO_DATE(' 2015-01-01 00:00:00',
 'SYYYY-MM-DD HH24:MI:SS',
 'NLS_CALENDAR=GREGORIAN')) );

Suggestion

Modify Table interval partition.