From Oracle to GaussDB
Source Data Type |
Converted Data Type |
Conversion Configuration |
---|---|---|
CHAR |
CHAR |
Mismatch character set If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent. |
VARCHAR |
VARCHAR |
Mismatch character set If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent. |
VARCHAR2 |
VARCHAR2 |
Mismatch character set If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent. |
NCHAR |
NCHAR |
Mismatch character set If you select This config will adjust the size of CHAR(n), VARCHAR(n), VARCHAR2(n), and NCHAR(n) such that there will not be overflow, the storage of characters converted by DRS and UGO is equivalent. |
NVARCHAR2 |
NVARCHAR2 |
- |
NUMBER |
NUMBER |
Number data type with zero scale If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent. |
NUMBER (6,3) |
NUMBER (6, 3) |
Number data type with zero scale If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent. |
NUMBER (6,0) |
NUMBER (6,0) |
Number data type with zero scale If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent. |
NUMBER (3) |
NUMBER (3) |
Number data type with zero scale If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent. |
NUMBER (6,-2) |
NUMBER (6,-2) |
Number data type with zero scale If you select No conversion will be happened. NUMBER will be retained as it is. GaussDB supports MUMBER, the storage of characters converted by DRS and UGO is equivalent. |
BINARY_FLOAT |
REAL |
- |
BINARY_DOUBLE |
BINARY_DOUBLE |
- |
FLOAT |
DOUBLE PRECISION |
Float datatype If you select The FLOAT/FLOAT(n) will be converted to DOUBLE PRECISION, the storage of characters converted by DRS and UGO is equivalent. |
INT |
NUMBER(38) |
Integer datatype If you select This config will convert INT, INTEGER, and SMALLINT to NUMBER(38), , the storage of characters converted by DRS and UGO is equivalent. |
INTEGER |
NUMBER(38) |
Integer datatype If you select This config will convert INT, INTEGER, and SMALLINT to NUMBER(38), , the storage of characters converted by DRS and UGO is equivalent. |
DATE |
DATE |
- |
TIMESTAMP |
TIMESTAMP(6) |
- |
TIMESTAMP_TZ |
TIMESTAMP(6) WITH TIME ZONE |
- |
TIMESTAMP_LTZ |
TIMESTAMP(6) WITH TIME ZONE |
- |
INTERVAL_YM |
INTERVAL YEAR TO MONTH |
- |
INTERVAL_DS |
INTERVAL DAY TO SECOND |
- |
BLOB |
BLOB |
- |
CLOB |
CLOB |
- |
NCLOB |
TEXT |
NCLOB datatype If you select The NCLOB will be converted into TEXT datatype, the storage of characters converted by DRS and UGO is equivalent. |
LONG |
TEXT |
LONG data type If you select The LONG type will be converted into TEXT data type, the storage of characters converted by DRS and UGO is equivalent. |
LONG_RAW |
BYTEA |
LONG RAW data type If you select The LONG RAW will be converted into BYTEA data type, the storage of characters converted by DRS and UGO is equivalent. |
RAW |
RAW |
- |
RowID |
CHAR(18) |
- |
NUMBER(*, 0) |
NUMBER(38,0) |
- |
For details about the configuration items, see Editing the Configurations During Migration from Oracle to GaussDB.
Feedback
Was this page helpful?
Provide feedbackThank 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