Oracle->DDM
| Data Type (Oracle) | Condition | Data Type (DDM) | Whether to Support Mapping |
|---|---|---|---|
| CHAR(n) | n<=255 | CHAR(n) | Yes |
| CHAR(n) | n>255 | VARCHAR(n) | Yes |
| VARCHAR(Size) | Length (row size) ≤ 65535 | VARCHAR(n) | Yes |
| VARCHAR(Size) | Length (row size) > 65535 | TEXT | Yes |
| VARCHAR2(n) | - | VARCHAR(n) | Yes |
| NCHAR(n) | n<=255 | NCHAR(n) | Yes |
| NCHAR(n) | n>255 | NVARCHAR(n) | Yes |
| NVARCHAR2(n) | - | NVARCHAR(n) | Yes |
| NUMBER(p,s) | s>0 | NUMBER(p,s) | Yes |
| NUMBER(p,s) | s<=0 | NUMBER(p-s,0) | Yes |
| BINARY_FLOAT | - | FLOAT | Yes |
| BINARY_DOUBLE | - | DOUBLE | Yes |
| FLOAT(b) | b<=99 | DECIMAL(b*0.30103*2,b*0.30103) | Yes |
| FLOAT(b) | b>99 | DOUBLE | Yes |
| DATE | - | DATETIME | Yes |
| TIMESTAMP | If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database. | TIMESTAMP | Yes |
| TIMESTAMP WITH LOCAL TIME ZONE | If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database. | TIMESTAMP | Yes |
| TIMESTAMP WITH TIME ZONE | If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database. | TIMESTAMP | Yes |
| INTERVAL | Incremental | VARCHAR(30) | No |
| INTERVAL | Full; 6 digit precision | VARCHAR(30) | Yes |
| BLOB | - | LONGBLOB | Yes |
| CLOB | - | LONGTEXT | Yes |
| NCLOB | - | LONGTEXT | Yes |
| LONG | - | LONGTEXT | Yes |
| LONG_RAW | - | LONGBLOB | Yes |
| RAW | - | VARBINARY | Yes |
| ROWID | - | VARCHAR(18) | Yes |
| XMLTYPE | - | LONGTEXT | Yes |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
