Forum Stats

  • 3,825,491 Users
  • 2,260,518 Discussions


Is it possible to replicate Views or Materialized View to Tables?

Yavuz B.
Yavuz B. Member Posts: 1 Green Ribbon

Hi *,

i haven't used OGG before but have requirements on customer side to replicate from a Oracle Source Database Views and Materialized View to Tables.

I have on the source side multiple Tables, to replicate those objects also to Tables on the Destination (also Oracle Database) side shouldn't be a problem (i think). But the customer has also Views and Materialized Views on the Source Database. The question is:

Is it possible to replicate the source Views and Mat. Views to Tables (1:1 Transform) so that i have on the Destination side Tables instead of the Views/Mat. Views.

Best regards