Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from Oracle to GaussDB/ U0100046: No more than 64 key values are allowed in each GaussDB partitioned table
Updated on 2025-10-22 GMT+08:00
View PDF
Share

U0100046: No more than 64 key values are allowed in each GaussDB partitioned table

Description

No more than 64 key values are allowed in each GaussDB partitioned table.

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 PARTITION_TEST (
    id NUMBER(10),
    numbers VARCHAR2(50)
)
PARTITION BY LIST (numbers)
(
    PARTITION p1 VALUES ('1',
'2',
'3',
'4',
'5',
'6',
'7',
'8',
'9',
'10',
'11',
'12',
'13',
'14',
'15',
'16',
'17',
'18',
'19',
'20',
'21',
'22',
'23',
'24',
'25',
'26',
'27',
'28',
'29',
'30',
'31',
'32',
'33',
'34',
'35',
'36',
'37',
'38',
'39',
'40',
'41',
'42',
'43',
'44',
'45',
'46',
'47',
'48',
'49',
'50',
'51',
'52',
'53',
'54',
'55',
'56',
'57',
'58',
'59',
'60',
'61',
'62',
'63',
'64',
'65'),
    PARTITION p2 VALUES ('66'),
    PARTITION p3 VALUES ('67')
);

Suggestion

Modify Support for scenarios where the key value of the list partition exceeds the limit.