[CMT8.4.1.1203]Cannot migrate number partition table to CUBRID via CMT

Details

  • Type: Improvement Improvement
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: CMT8.4.1.201203
  • Fix Version/s: CMT8.4.1.201203
  • Component/s: CUBRID Migration Toolkit
  • Labels:
    None
  • Environment:

    CUBRID:8.4.1.1018
    CMT:8.4.1.0010
    SourceDB:oracle

Description

1 Create one table in oracle.

CREATE TABLE PRANGE1
( I NUMBER,
P NUMBER
) PARTITION BY RANGE (P)
(PARTITION P1_1000 VALUES LESS THAN (1000),
PARTITION P1_2000 VALUES LESS THAN (2000))

2 Do migration.
3 But partition table in cubrid doesn't support numeric data type. and in migration process, only support migration from number to numeric.

So the partition will be lost.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
曹轶麟 added a comment -

CUBRID can't support creating table partitions with NUMBER type

Show
曹轶麟 added a comment - CUBRID can't support creating table partitions with NUMBER type
Hide
Permalink
高艳铭 added a comment -

Closed in CMT8.4.1.1203

The number data type only convert to varchar data type now.

Show
高艳铭 added a comment - Closed in CMT8.4.1.1203 The number data type only convert to varchar data type now.

People

  • Assignee:
    高艳铭
    Reporter:
    高艳铭
Vote (0)
Watch (0)

Dates

  • Due:
    Created:
    Updated:
    Resolved: