0 Replies Latest reply: Jun 19, 2012 12:34 AM by 944464 RSS

    CDC on Materialized Views!!

    944464
      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