Mysql – oracle-thesql fast refresh materialized view

materialized-viewMySQLoracleoracle-12c

Is is possible to Create Fast refresh enabled Materialized view from MySQL to Oracle . i know steps for oracle to oracle Fast refresh enabled Materialized view. But now the scenario is need to transfer number of records from MySQL to oracle via db-link with use of materialized view. But every time i need to make Complete Refresh which is time consuming.
so is it possible to create fast refresh materialized view for MySQL to Oracle ?

Best Answer

A fast refresh requires (among many other things) materialized view logs on source tables.

Refresh types

You can perform fast refreshes of materialized views only when the master table or master materialized view has a materialized view log.

enter image description here

That functionality is specific to and implemented in Oracle, and not available in MySQL. It is not like no other database can provide the logically similar functionality, but this is the Oracle implementation, that works with Oracle databases.