Datasync Dataload : Image Of BLOB Datatype From RDBMS Table Loaded Into DBaaS As UNKNOWN-UNSUPPORTED

(Doc ID 2185734.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 15.2.4.0.0 version, Data Loading

When creating the a target table containing image data, we can see that

ACTUAL BEHAVIOR
---------------
Datasync puts UNKNOWN-UNSUPPORTED in the create table query for the image data

EXPECTED BEHAVIOR
-----------------------
DataSync should put BLOB datatype

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are not able to load Image data from RDBMS to DBaaS

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms