GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
System Management and Integration
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jun 18, 2012 10:34 PM by 944464
CDC on Materialized Views!!
Jun 18, 2012 10:34 PM
Currently Being Moderated
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.
Track in Communications
- 10 points
- 5 points