在异构数据库迁移中,往往会涉及到字段类型的差异。收集DM数据库与ORACLE类型的转换。作为笔记参考。
参照DTS迁移工具中的映射参考。
ORACLE | DM | |
BLOB | BLOB | |
FLOAT | FLOAT | |
ARRAY | LONGVARBINARY | |
SYS.XMLTYPE | CLOB | |
NROWID | VARBINARY | |
RAW | VARBINARY | |
NCHAR | NCHAR | |
TIMESTAMP WITH LOCAL TIME ZONE | TIMESTAMP WITH LOCAL TIME ZONE | |
XMLTYPE | CLOB | |
LONG RAW | LONGVARBINARY | |
TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE | |
UROWID | VARBINARY | |
TIMESTAMP | TIMESTAMP | |
INTERVALDS | INTERVAL DAY TO SECOND | |
INTERVALYM | INTERVAL YEAR TO MONTH | |
AQ$_SUBSCRIBERS | LONGVARBINARY | |
lONG | TEXT | |
NCLOB | CLOB | |
NUMBER | NUMBER | |
CLOB | CLOB | |
VARCHAR2 | VARCHAR2 | |
BOOLEAN | BIT | |
NVARCHAR2 | NVARCHAR | |
DATE | TIMESTAMP | |
REF | LONGVARBINARY | |
BOOL | BIT | |
BINARY_FLOAT | FLOAT | |
ROWID | BINARY | |
STRUCT | LONGVARBINARY | |
BINARY_DOUBLE | DOUBLE | |
CHAR | CHAR | |
VARCHAR | VARCHAR | |
DOUBLE PRECISION | DOUBLE PRECISION | |
INTFRVAI DAV TO SFCOND | INTFRVAI DAV TO SFCOND | |
INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH | |
BFILE | BFILE | |
REAL | REAL |
相关说明:1、在DM数据库开启了兼容模式下,timestamp与oracle的date类型是相同。这点是与ORACLE自有区别较大的地方,且timestamp默认精度为6
2、官方手册上没有NVARCHAR及NVARCHAR2的类型说明,主要是满足一些复杂数据迁移时保持数据一致性使用。