Restrictions on use of Oracle DB data source

The following restrictions apply to the use of an Oracle DB data source:

Only Oracle Version 12.2 or greater is currently supported.

Only the following data-types are supported for field mappings:

VARCHAR2

CLOB

NUMBER

INTEGER

DATE

TIMESTAMP

INTERVAL

DECIMAL (Number with scale >0)

BINARY DOUBLE

NCLOB

These can be used in Simple, Assignment, Value Mappings and Lookups.

Attachment and Image Migration is supported, but only for attachments previously archived into the SN_SYS_ATTACHMENT table. Attachment migration is not supported for Oracle versions below 12.2.