The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and an Oracle target:
Oracle Source Data Type
Oracle Target Data Type
binary_double
binary_double
binary_float
binary_float
blob
blob
char(s byte), 1 <= size <= 2000
char(s byte), 1 <= size <= 2000
char(s char), 1 <= size <= 2000
char(s char), 1 <= size <= 2000
clob
clob
date
date
float(precision), 1 <= p <= 126
float(precision), 1 <= p <= 126
integer
integer
long raw
long raw
long(2147483648 byte)
long(2147483648 byte)
nchar(s char), 1 <= size <= 2000
nchar(s char), 1 <= size <= 2000
nclob
nclob
number
number
number(*,s), -84 <= s <= 127
number(*,s), -84 <= s <= 127
number(p,s), 1 <= p <= 38, -84 <= s <= 127
number(p,s), 1 <= p <= 38, -84 <= s <= 127
nvarchar2(s char), 1 <= size <= 4000
nvarchar2(s char), 1 <= size <= 4000
raw(size), 1 <= size <= 2000
raw(size), 1 <= size <= 2000
rowid
rowid
timestamp(precision) with time zone, 0 <= p <= 9
timestamp(precision) with time zone, 0 <= p <= 9
timestamp(precision), 1 <= p <= 9
timestamp(precision), 1 <= p <= 9
varchar2(s byte), 1 <= size <= 4000
varchar2(s byte), 1 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
xml
clob
LOB limitations
Database ingestion and replication initial load, incremental load, and combined load jobs can replicate data from Oracle BLOB, CLOB, NCLOB, LONG, LONG RAW, and XML columns to Oracle targets. LOB column data might be truncated on the target. For all of the Oracle LOB data types and this target, the truncation point is 16777216 bytes. 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 with any load type:
•"ANY" types such as ANYTYPE, ANYDATA, ANYDATASET
•Extended types
•INTERVAL
•JSON
•BFILE type for storing LOB data externally
•UROWID
•Spatial types such as SDO_GEOMETRY
•User-defined types such as OBJECT, REF, VARRAY, nested table types
Source columns that have unsupported data types are excluded from the target definition.
If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure an Oracle target.