Striim Migration Service for Google Cloud Documentation

Oracle to PostgreSQL data type support and correspondence

Oracle type

PostgreSQL type

ADT

unsupported

ARRAY

unsupported

BFILE

unsupported

BINARY_DOUBLE

double precision

BINARY_FLOAT

real

BFILE

unsupported

BLOB

bytea

An insert or update containing a column of this type generates two Oracle CDC log entries: an insert or update in which the value for this column is null, followed by an update including the value.

CHAR

character

CLOB

text (a primary or unique key must exist on the Oracle table)

An insert or update containing a column of this type generates two Oracle CDC log entries: an insert or update in which the value for this column is null, followed by an update including the value.

DATE

date

FLOAT

double precision

INTERVALDAYTOSECOND

interval

INTERVALYEARTOMONTH

interval

LONG

unsupported: Oracle recommends using CLOB instead.

LONG RAW

unsupported: Oracle recommends using CLOB instead.

NCHAR

character

NCLOB

text (a primary or unique key must exist on the Oracle table)

NESTED TABLE

unsupported

NUMBER

numeric

NVARCHAR2

character varying

RAW

bytea

REF

unsupported

ROWID

unsupported

TIMESTAMP

timestamp without time zone

TIMESTAMP WITHLOCALTIMEZONE

timestamp with time zone

TIMESTAMP WITHTIMEZONE

timestamp with time zone

UDT

unsupported

UROWID

unsupported

VARCHAR2

character varying

VARRAY

unsupported

XMLTYPE

Supported only by Oracle 12c and later. When DictionaryMode is OnlineCatalog, values in any XMLType columns will be set to null. When DictionaryMode is OfflineCatalog, reading from tables containing XMLType columns is not supported.

For assistance in migrating tables containing unsupported types, Contact SMSGC support.