Oracle Database Discussions

Hi all,

I have four tables a1 (1.8 million) , b1 (2.5 million) , c1 and d1. a1 and b1 are huge tables. A view is written to get the details using these 4 tables. I need to convert the view to materialized view.

I use this view regurarly. I am little confused about setting the refresh time for the materialized view because this query can be called at any time. I need guidance on how I can convert the view into a materialized view.


Replies are much appreciated. Thanks in advance.

Regards.