Home Topics HVR Real-time Replicator Tips & Tricks How to capture from an Oracle Materialized view
This topic contains 0 replies, has 1 voice, and was last updated by Frank Knot 1 week, 1 day ago.
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.
You must be logged in to reply to this topic.
© 2017 HVR Software