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

Yavuz B.

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

Yavuz

ORASCN

Hi Yavuz,

Please check the below link,

https://docs.oracle.com/en/middleware/goldengate/core/12.3.0.1/ggodb/1-understanding-whats-supported.html#GUID-6D86AA21-0F37-4354-963E-8300CC30AF3A

Check the below one,

Tables, Views, and Materialized Views

Regards,

Veera

Yavuz B.

Hi,

thanks for your answer. This is,when i understood it correctly from the document, about the Table, View and Materialized View support of Oracle Golden Gate.

My question was more in the direction of: Is it possible to capture data from a View on the Source side and put it in a Table on the Target side.

best regards

Yavuz

Gururaj0-Oracle

Yavuz,

Yes it is possible. You need to map the underlying table of the view and not the view itself( from Source) to the View on the Target Side. Then replication of the view is possible as long as the structures of the source tables and a target view are identical.

Regards

Gururaj