0

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
  • 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
    Dec 6, 2018 at 5:56

1 Answer 1

1

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.

1
  • ok any alternatives for this which can reduce time consuming ?
    – Ray
    Dec 6, 2018 at 5:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.