Re: CDC with MV

Posted by ErmanArslansOracleBlog on Feb 25, 2021; 3:09pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/CDC-with-MV-tp9396p9399.html

I am not that expert on Striim and Striim isn't in my focus either (I only support it sometimes in some cases), but I will try to give you an answer for this.

Striim does CDC from Oracle , and its abilities are normally depend on the abilities of CDC mechanism on Oracle.

Please check the MOS note named ->

We have a question "Does CDC support the usage of MVIEW as a source table ?" there and we have an answer.. So that will help you decide.. Generally, CDC from MVIEW should work (but not guaranteed!) as per "ordinary" tables for atomic, mv log based fast refresh. But ! you need to ask it to "Striim" to be sure that Oracle Reader can perform okay with MVs.