PostgreSQL Source and Oracle Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a PostgreSQL source and an Oracle target:

PostgreSQL Source Data Type	Oracle Target Data Type
bigint	number(19)
bit varying(precision), 1 <= p <= 83886080	blob
bit(precision), 1 <= p <= 83886080	blob
boolean	char(1 char)
box	blob
character varying(size), 1 <= s <= 1501	char(s char), 4 <= s <= 2000
character varying(size), 2001 <= s <= 10485760	clob
character(size), 1 <= s <= 2000	char(s char), 4 <= s <= 2000
character(size), 2100 <= s <= 10485760	clob
cidr	char(45 char)
circle	blob
date	date
daterange	char(29 char)
double precision	binary_double
inet	char(45 char)
int4range	char(25 char)
int8range	char(43 char)
integer	number(10)
json	clob
jsonb	clob
line	blob
lseg	blob
macaddr	char(17 char)
macaddr8	char(23 char)
money	number(19,2)
numeric	clob
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38	number(p,s), 1 <= p <= 38, 0 <= s <= 38
numeric(p,s), 39 <= p <= 1000, 39 <= s <= 1000	char(s char), 42 <= s <= 1003
numrange	clob
path	blob
point	blob
polygon	blob
real	binary_double
smallint	number(5)
time(precision) with time zone, 0 <= p <= 6	char(s char), 48 <= s <= 55
time(precision) without time zone, 0 <= p <= 6	timestamp(precision), 0 <= p <= 6
timestamp(precision) with time zone, 0 <= p <= 6	timestamp(precision) with time zone, 0 <= p <= 6
timestamp(precision) without time zone, 0 <= p <= 0	date
timestamp(precision) without time zone, 1 <= p <= 6	timestamp(precision), 1 <= p <= 6
tsrange	char(63 char)
tstzrange	char(75 char)
uuid	char(36 char)
xml	clob

Limitations

•Database ingestion and replication initial load jobs can replicate data from PostgreSQL bytea, text, xml, and other large-object columns to Oracle targets if you select the Include LOBs option under Advanced on the Source page of the task wizard. LOB column data is truncated before being written to the target if it is greater in size than a byte limit that depends on the LOB type. For more information, see the "Include LOBs" description in Configure a PostgreSQL source.

Unsupported source data types

For initial load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types:

•ABSTIME

•Array types

•NAME

•Object identifier types

•PG_LSN

•RELTIME

•Text search types:

- TSQUERY
- TSVECTOR

•User-defined types

For incremental load and initial and incremental load jobs, Database Ingestion and Replication does not support the following PostgreSQL data types, in addition to those not supported for initial load jobs:

•Spatial types

- Box
- Circle
- Line
- LSeg
- Path
- Point
- Polygon

•Unbounded varying types

Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have these data types.