Oracle Database Discussions

I have to migrate data from SQL server tables to oracle tables.

Iam facing problem for tables in oracle which have BLOB datatype.
There is no BLOB datatype in SQL server,In place of BLOB there is image datatype in SQL Server.
Iam using Oracle Heterogenous Services to migrate the data,Using Merge statement and database link.

When Iam running the statement
MERGE INTO METRICS_DETAIL ora
USING METRICS_DETAIL@testlink sql
ON(ora.METRICS_DETAIL_ID = sql.METRICS_DETAIL_ID)
WHEN MATCHED THEN
UPDATE SET ora.COLLECTION_DATE = sql.COLLECTION_DATE
, ora.SEND_DATE = sql.SEND_DATE
, ora.METRICS_FILE = sql.METRICS_FILE
, ora.CREATED_BY = sql.CREATED_BY
, ora.CREATED_DATE = sql.CREATED_DATE
, ora.UPDATED_BY = sql.UPDATED_BY
, ora.UPDATED_DATE = sql.UPDATED_DATE
WHEN NOT MATCHED THEN
INSERT( ora.METRICS_DETAIL_ID
, ora.COLLECTION_DATE
, ora.SEND_DATE
, ora.METRICS_FILE
, ora.CREATED_BY
, ora.CREATED_DATE
, ora.UPDATED_BY
, ora.UPDATED_DATE)
VALUES( sql.METRICS_DETAIL_ID
, sql.COLLECTION_DATE
, sql.SEND_DATE
, sql.METRICS_FILE
, sql.CREATED_BY
, sql.CREATED_DATE
, sql.UPDATED_BY
, sql.UPDATED_DATE);

I am getting the following error-


ERROR at line 7:
ORA-00932: inconsistent datatypes: expected BLOB got LONG BINARY

here metrics_file is the BLOB field in oracle

Can any one suggest me how to migrate Image datatype to BLOB???