Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
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 19, 2012 12:34 AM by
CDC on Materialized Views!!
Jun 19, 2012 12:34 AM
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.
This content has been marked as final.
Show 0 replies