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`