Mapping Between Oracle and DWS Field Types
DataArts Migration converts the source field type to the destination field type based on the default rule, and creates tables and synchronizes data in real time.
Field Type Mapping Rules
The following table lists the field types supported by a job that migrates data from Oracle to DWS.
| Type | Oracle Data Type | DWS Data Type | Description |
|---|---|---|---|
| Numeric | NUMBER | NUMBER | Alias for NUMERIC, compatible with Oracle |
| FLOAT | FLOAT8 | Double-precision floating point number (8 bytes) | |
| BINARY_FLOAT | FLOAT4 | Single-precision floating point number (4 bytes) | |
| DECIMAL(M,D) | NUMBER | Equivalent to NUMBER | |
| BINARY_DOUBLE | FLOAT8 | Double-precision floating point number (8 bytes) | |
| Time | DATE | TIMESTAMP | Date and time |
| TIMESTAMP [(p)] | TIMESTAMP [(p)] | Date and time | |
| TIMESTAMP [(p)] WITH TIME ZONE | TIMESTAMPTZ[(p)] | Date and time, with the time zone | |
| TIMESTAMP [(p)] WITH LOCAL TIME ZONE | TIMESTAMPTZ[(p)] | Date and time, with the local time zone | |
| String | CHAR(n) | CHAR(n) | Fixed-length string, filled with spaces |
| NCHAR(n) | NCHAR(n) | Fixed-length string, filled with spaces | |
| NVARCHAR2(n) | NVARCHAR(n) | Variable-length string | |
| VARCHAR(n) | VARCHAR(n) | Variable-length string | |
| VARCHAR2(n) | VARCHAR(n) | Variable-length string |
Other Oracle data types, such as CLOB and BLOB, are not supported by Migration Oracle.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
