Is it possible to capture from view and materialized view in Oracle?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #14898
    Pallavik
    Keymaster

    Problem Summary:

    Is it possible to capture from view and materialized view in Oracle?

    Answer:

    HVR can’t replicate from a view in Oracle however it can do log based capture on materialized views from Oracle. Materialized view is just a table which is periodically updated by Oracle using view definition. In HVR Table Select/ Table Explore can select materialized views and whenever this view is updated it is replicated as a normal table.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us