Home Topics HVR Real-time Replicator Knowledge Base How to capture from an Oracle Materialized view
HVR is able to capture (log based) from an Oracle Materialized View. This type of view is actually just a table which is updated periodically by Oracle using the view definition.
To capture from such a view, its definition has to be entered manually (as a table) in the HVR catalogs. Table select / table explore currently only selects regular tables.
On the target, the contents of the materialized view will be replicated to a regular table.
© 2020 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.