Oracle to Redshift mapping

AutoSync maps Oracle object types to the following Redshift column types:

Oracle object type Redshift column type
char char
varchar2 varchar
nchar varchar
nvarchar2 varchar
number decimal
number (without precision and scale) double precision
float double precision
binary_float double precision
binary_double double precision
long varchar
long raw varbyte
raw varbyte
date date
timestamp timestamp
timestamp with time zone timestamptz
timestamp with local time zone timestamp
interval year to month varchar
interval day to second varchar
blob varbyte
clob varchar
nclob varchar
bfile varbyte
rowid varchar
urowid varchar
anydata varchar
xmltype varchar