Netezza Source Data Type | Oracle Target Data Type |
|---|---|
bigint | number(19) |
boolean | char(1 char) |
byteint | number(3) |
char(size), 1 <= size <= 3001 | varchar2(s char), 1 <= s <= 3001 |
char(size), 4096 <= size <= 64000 | clob |
date | date |
double | binary_double |
integer | number(10) |
interval | varchar2(55 char) |
nchar(size), 1 <= size <= 901 | nvarchar2(s char), 1 <= s <= 901 |
nchar(size), 1024 <= size <= 1100 | char(2000 char) |
nchar(size), 2100 <= size <= 16000 | clob |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38 | number(p,s), 1 <= p <= 38, 1 <= s <= 38 |
nvarchar(1) | nvarchar2(1 char) |
nvarchar(1001) | char(2000 char) |
nvarchar(size), 2001 <= s <= 16000 | clob |
real | binary_float |
smallint | number(5) |
st_geometry(precision), 1 <= p <= 1001 | raw(size), 1 <= size <= 1001 |
st_geometry(precision), 2001 <= p <= 63001 | blob |
time | timestamp(6) |
timestamp | timestamp(6) |
timetz | timestamp(precision) with time zone, 6 <= p <= null |
varbinary(size), 1 <= size <= 1001 | raw(size), 1 <= size <= 1001 |
varbinary(size), 2001 <= size <= 64000 | blob |
varchar(size), 1 <= size <= 3001 | varchar2(s char), 1 <= s <= 3001 |
varchar(size), 4001 <= size <= 64000 | clob |