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 ?
-
This discusses the 'best' ways to do Materialized Views in MySQL. But, as you already know, the work must be done by the user. I don't think any of them correspond to a Fast Refresh MV. But they might be "good enough"?Rick James– Rick James2018年12月06日 05:56:13 +00:00Commented Dec 6, 2018 at 5:56
1 Answer 1
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.
-
ok any alternatives for this which can reduce time consuming ?Ray– Ray2018年12月06日 05:27:06 +00:00Commented Dec 6, 2018 at 5:27
Explore related questions
See similar questions with these tags.