This discussion is archived
0 Replies Latest reply: Jun 18, 2012 10:34 PM by 944464 RSS

CDC on Materialized Views!!

944464 Newbie
Currently Being Moderated
Hi Experts,

Whether CDC works on MViews. I am new to ODI.

The issue is due to accessing a table with one column as CLOB. As CLOB is not accessible over DB Link the code fails with the following error


ODI-1228: Task link_interface (Integration) fails on the target ORACLE connection source_db.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB


The table is having CDC defined. Whether the code works if an MView is defined on the table with
REFRESH FAST ON COMMIT enabled.

Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points