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 ?

  • Oracle has a zillion bells and whistles. "Fast refresh materialized view" is one of many that does not exist on MySQL. For us ignorant MySQL DBAs, please define what that does. – Rick James Dec 3 '18 at 17:55
  • @ Rick James. I know that like mviews does not exists in MYSQL. so that's why i am asking for alternatives – vvs Dec 6 '18 at 5:26
  • 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 '18 at 5:56
0

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.

  • ok any alternatives for this which can reduce time consuming ? – vvs Dec 6 '18 at 5:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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