Database Ingestion and Replication > Default data-type mappings > Oracle Source and Amazon Redshift Target
  

Oracle Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and an Amazon Redshift target:
Oracle Source Data Type
Amazon Redshift Target Data Type
binary_double
float8
binary_float
float4
blob
binary varying(1024000)
char(s byte), 1 <= size <= 2000
character varying(size), 4 <= size <= 2000
char(s char), 1 <= size <= 2000
character varying(size), 4 <= size <= 8000
clob
character varying(65535)
date
timestamp without time zone
float(precision), 1 <= p <= 126
character varying(255)
integer
character varying(255)
long raw
varbyte
long(2147483648 byte)
character varying(65535)
nchar(s char), 1 <= size <= 2000
character varying(size), 4 <= size <= 8000
nclob
character varying(65535)
number
number
number(*,s), -84 <= s <= 127
character varying(255)
number(38,s), 0 <= s <= 37
numeric(38,s), 0 <= s <= 37
number(p,s), 1 <= p <= 38, -37 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, -84 <= s <= 127
character varying(size), 40 <= size <= 130
number(p,s), 10 <= p <= 38, -28 <= s <= 37
numeric(p,s), 10 <= p <= 38, 0 <= s <= 37
number(p,s), 11 <= p <= 38, -27 <= s <= 37
numeric(p,s), 11 <= p <= 38, 0 <= s <= 37
number(p,s), 12 <= p <= 38, -26 <= s <= 37
numeric(p,s), 12 <= p <= 38, 0 <= s <= 37
number(p,s), 13 <= p <= 38, -25 <= s <= 37
numeric(p,s), 13 <= p <= 38, 0 <= s <= 37
number(p,s), 14 <= p <= 38, -24 <= s <= 37
numeric(p,s), 14 <= p <= 38, 0 <= s <= 37
number(p,s), 15 <= p <= 38, -23 <= s <= 37
numeric(p,s), 15 <= p <= 38, 0 <= s <= 37
number(p,s), 16 <= p <= 38, -22 <= s <= 37
numeric(p,s), 16 <= p <= 38, 0 <= s <= 37
number(p,s), 17 <= p <= 38, -21 <= s <= 37
numeric(p,s), 17 <= p <= 38, 0 <= s <= 37
number(p,s), 18 <= p <= 38, -20 <= s <= 37
numeric(p,s), 18 <= p <= 38, 0 <= s <= 37
number(p,s), 19 <= p <= 38, -19 <= s <= 37
numeric(p,s), 20 <= p <= 38, 0 <= s <= 37
number(p,s), 2 <= p <= 38, -36 <= s <= 37
numeric(p,s), 2 <= p <= 38, 0 <= s <= 37
number(p,s), 21 <= p <= 38, -17 <= s <= 37
numeric(p,s), 21 <= p <= 38, 0 <= s <= 37
number(p,s), 22 <= p <= 38, -16 <= s <= 37
numeric(p,s), 22 <= p <= 38, 0 <= s <= 37
number(p,s), 23 <= p <= 38, -15 <= s <= 37
numeric(p,s), 23 <= p <= 38, 0 <= s <= 37
number(p,s), 24 <= p <= 38, -14 <= s <= 37
numeric(p,s), 24 <= p <= 38, 0 <= s <= 37
number(p,s), 25 <= p <= 38, -13 <= s <= 37
numeric(p,s), 25 <= p <= 38, 0 <= s <= 37
number(p,s), 26 <= p <= 38, -12 <= s <= 37
numeric(p,s), 26 <= p <= 38, 0 <= s <= 37
number(p,s), 27 <= p <= 38, -11 <= s <= 37
numeric(p,s), 27 <= p <= 38, 0 <= s <= 37
number(p,s), 28 <= p <= 38, -10 <= s <= 37
numeric(p,s), 28 <= p <= 38, 0 <= s <= 37
number(p,s), 29 <= p <= 38, -9 <= s <= 37
numeric(p,s), 29 <= p <= 38, 0 <= s <= 37
number(p,s), 3 <= p <= 38, -35 <= s <= 37
numeric(p,s), 3 <= p <= 38, 0 <= s <= 37
number(p,s), 30 <= p <= 38, -8 <= s <= 37
numeric(p,s), 30 <= p <= 38, 0 <= s <= 37
number(p,s), 31 <= p <= 38, -7 <= s <= 37
numeric(p,s), 31 <= p <= 38, 0 <= s <= 37
number(p,s), 32 <= p <= 38, -6 <= s <= 37
numeric(p,s), 32 <= p <= 38, 0 <= s <= 37
number(p,s), 33 <= p <= 38, -5 <= s <= 37
numeric(p,s), 33 <= p <= 38, 0 <= s <= 37
number(p,s), 34 <= p <= 38, -4 <= s <= 37
numeric(p,s), 34 <= p <= 38, 0 <= s <= 37
number(p,s), 35 <= p <= 38, -3 <= s <= 37
numeric(p,s), 35 <= p <= 38, 0 <= s <= 37
number(p,s), 36 <= p <= 38, -2 <= s <= 37
numeric(p,s), 36 <= p <= 38, 0 <= s <= 37
number(p,s), 37 <= p <= 38, -1 <= s <= 37
numeric(p,s), 37 <= p <= 38, 0 <= s <= 37
number(p,s), 4 <= p <= 38, -34 <= s <= 37
numeric(p,s), 4 <= p <= 38, 0 <= s <= 37
number(p,s), 5 <= p <= 38, -33 <= s <= 37
numeric(p,s), 5 <= p <= 38, 0 <= s <= 37
number(p,s), 6 <= p <= 38, -32 <= s <= 37
numeric(p,s), 6 <= p <= 38, 0 <= s <= 37
number(p,s), 7 <= p <= 38, -31 <= s <= 37
numeric(p,s), 7 <= p <= 38, 0 <= s <= 37
number(p,s), 8 <= p <= 38, -30 <= s <= 37
numeric(p,s), 8 <= p <= 38, 0 <= s <= 37
number(p,s), 9 <= p <= 38, -29 <= s <= 37
numeric(p,s), 9 <= p <= 38, 0 <= s <= 37
nvarchar2(s char), 1 <= size <= 4000
character varying(size), 4 <= size <= 16000
raw(size), 1 <= size <= 2000
varbyte
rowid
character varying(18)
timestamp(precision) with time zone, 0 <= p <= 6
timestamp with time zone
timestamp(precision) with time zone, 7 <= p <= 9
character varying(29)
timestamp(precision), 1 <= p <= 6
timestamp without time zone
timestamp(precision), 7 <= p <= 9
character varying(size), 27 <= s <= 29
varchar2(s byte), 1 <= size <= 4000
character varying(size), 4 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
character varying(size), 4 <= size <= 16000
xml
character varying(65535)
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, LONG, LONG RAW, NCLOB, and XML columns to Amazon Redshift targets. LOB column data might be truncated on the target. The truncation point depends on the data type and target type. For more information, see the "Include LOBs" description in Configure an Oracle source.
Unsupported source data types
Database Ingestion and Replication does not support the following Oracle source data types:
Source columns that have unsupported data types are excluded from the target definition.