Data Type Mapping for Migration from Oracle to DWS

**Table 1** Data type mapping for migration from Oracle to DWS
Oracle Data Type	DWS Data Type	Mapping Supported or Not
CHAR	CHAR	Yes
VARCHAR	VARCHAR	Yes
VARCHAR2	VARCHAR	Yes
NCHAR	NCHAR	Yes
NVARCHAR2	NVARCHAR	Yes
NUMBER	NUMBER	Yes
BINARY_FLOAT	REAL	Yes
BINARY_DOUBLE	DOUBLE	Yes
FLOAT	FLOAT/REAL	Yes
DATE	TIMESTAMP	Yes
TIMESTAMP	TIMESTAMP If the precision value (fsp) is specified, the value must be in the range of 0 to 6. Value 0 indicates that there is no decimal part. If the value is not specified, the default precision is 0.	Yes
TIMESTAMP WITH TIME ZONE	TIMESTAMPTZ If the precision value (fsp) is specified, the value must be in the range of 0 to 6. Value 0 indicates that there is no decimal part. If the value is not specified, the default precision is 0.	Yes
TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMPTZ If the precision value (fsp) is specified, the value must be in the range of 0 to 6. Value 0 indicates that there is no decimal part. If the value is not specified, the default precision is 0.	Yes
INTERVAL	INTERVAL	Yes
BLOB	BYTEA	Yes
CLOB	CLOB	Yes
NCLOB	TEXT	Yes
BFILE	Not supported	No
LONG	TEXT	Yes
LONG_RAW	BYTEA	Yes
RAW (non-primary key column and non-unique key column)	BYTEA	Yes
RAW (primary key column and unique key column)	VARCHAR	Yes
ROWID	CHARACTER(18)	Yes
UROWID	Not supported	No
XMLTYPE	TEXT	Yes
SDO_GEOMETRY	Not supported	No