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 ?
1 Answer
A fast refresh requires (among many other things) materialized view logs on source tables.
You can perform fast refreshes of materialized views only when the master table or master materialized view has a materialized view log.
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.