How do I capture from an Oracle Materialized view?
HVR cannot replicate from a view in Oracle however it can do log-based capture on Oracle Materialized Views from Oracle.
A materialized view is just a table that is periodically updated by Oracle using view definition.
In HVR Table Select/ Table Explore can select materialized views and whenever this materialized view is updated it is replicated as a normal table.
On the target, the contents of the materialized view will be replicated to a regular table.