Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Oracle Source Data Type | Amazon Redshift Target Data Type |
|---|---|
binary_double | double precision |
binary_float | real |
char(s byte), 1 <= s <= 2000 | character varying( size ), 4 <= s <= 2000 |
char(s char), 1 <= s <= 2000 | character varying( size ), 4 <= s <= 8000 |
date | timestamp without time zone |
float( precision ), 1 <= p <= 126 | character varying(255) |
integer | character varying(255) |
long raw | character varying(65535) |
long(2147483648 byte) | character varying(65535) |
nchar(s char), 1 <= s <= 2000 | character varying( size ), 4 <= s <= 8000 |
number | character varying(255) |
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 <= s <= 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 <= s <= 4000 | character varying( size ), 4 <= s <= 16000 |
raw( size ), 1 <= s <= 4000 | character varying( size ), 2 <= s <= 8000 |
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( size ), 67 <= s <= 69 |
timestamp( precision ), 1 <= p <= 6 | timestamp without time zone |
timestamp( precision ), 7 <= p <= 9 | character varying( size ), 27 <= s <= 29 |
varchar2(s byte), 1 <= s <= 4000 | character varying( size ), 4 <= s <= 4000 |
varchar2(s char), 1 <= s <= 4000 | character varying( size ), 4 <= s <= 16000 |
