mtkweb迁移工具bug?? 1.目标库版本不兼容Oracle;2.oracle的表字段类型varchar2迁移到gbase8s后变成text?
> select dbinfo('version_gbase','full') from dual;
(constant)
GBase8sV8.8_3.6.5_2L1_1
1 row(s) retrieved.
Elapsed time: 0.002 sec
https://www.gbase.cn/download/gbase-8s-1?category=TOOLKIT

1.迁移任务配置提示目标库版本[2.2.0]不支持Oracle兼容或MySQL兼容,gbase版本是GBase8sV8.8_3.6.5_2L1_1啊,怎么会不兼容呢?所以选择不兼容继续。
>select dbinfo('version_gbase','full') from dual;
(constant)
GBase8sV8.8_3.6.5_2L1_1
1 row(s) retrieved.
Elapsed time: 0.002 sec

2.迁移后字段类型不对
oracle11.2.0.4的表:
SQL> desc SALES_DATA;
Name Null? Type
----------------------------------------- -------- ----------------------------
SALE_ID NOT NULL NUMBER
SALE_DATE NOT NULL DATE
PRODUCT_ID NUMBER
AMOUNT NUMBER(10,2)
REGION VARCHAR2(20)
迁移配置里边字段映射本身是对的,但迁移后region字段VARCHAR2(20)类型会变成text



评论
请下载新版工具升级,此问题已解决
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25050
- 42023-09-25浏览数:18521
- 52020-05-11浏览数:17526