Materialized views for 53 tables

Posted by Roshan on Jan 15, 2018; 6:12pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Materialized-views-for-53-tables-tp4943.html

Hi Erman,

Oracle Database 12.1.0.2

Red Hat linux 6



 

I am following

 

https://oracle-base.com/articles/misc/materialized-views

 

to setup materialized view for 53 tables. I would like to know if I need to create 53 materialized views(1 for each tables) or only 1 materialized view will be enough.

 

The materialized view will be used to query tables for reporting.

MVtables.txt
 

Thanks,

Roshan