Database Ingestion and Replication

Back Next

Oracle Source and PostgreSQL Target

The following table identifies the recommended data-type mappings for

configurations with an Oracle source and a PostgreSQL target:

Oracle Source Data Type	PostgreSQL Target Data Type
binary_double	double precision
binary_float	real
blob	bytea
char(s byte), 1 <= s <= 2000	character varying(`size`), 1 <= size <= 500
char(s char), 1 <= s <= 2000	character varying(`size`), 1 <= size <= 2000
clob	text
date	timestamp(`precision`) without time zone, 0 <= p <= null
float(`precision`), 1 <= p <= 126	character varying(255)
integer	character varying(255)
long raw	bytea
long(2147483648 byte)	text
nchar(s char), 1 <= s <= 2000	character varying(`size`), 1 <= s <= 2000
nclob	text
number	character varying(255)
number(*,s), -84 <= s <= 127	character varying(255)
number(p,s), 1 <= p <= 38, -84 <= s <= 127	numeric(p,s), 1 <= p <= 127, 0 <= s <= 127
nvarchar2(s char), 1 <= s <= 4000	character varying(`size`), 1 <= s <= 4000
raw(`size`), 1 <= s <= 2000	bytea
rowid	character(18)
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp(`precision`) with time zone, 0 <= p <= 6
timestamp(`precision`) with time zone, 7 <= p <= 9	character varying(`size`), 67 <= size <= 69
timestamp(`precision`), 1 <= p <= 6	timestamp(`precision`) without time zone, 1 <= p <= 6
timestamp(`precision`), 7 <= p <= 9	character varying(`size`), 27 <= size <= 29
varchar2(s byte), 1 <= s <= 4000	character varying(`size`), 1 <= size <= 1000
varchar2(s char), 1 <= s <= 4000	character varying(`size`), 1 <= size <= 4000
xml	bytea

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 PostgreSQL targets. LOB column data might be truncated on the target. For more information, see the "Include LOBs" description in Configuring the source.

Columns that have the LONG, LONG RAW, and XML data types are supported in initial load jobs and in incremental load and combined load jobs that use the

Query-based

CDC method. However, jobs that use the

Log-based

CDC method do not replicate data from these columns to the generated target table.

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