Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

materialized view with multiple tables

RobeenJan 15 2018 — edited Jan 23 2018

Oracle Database 12.1.0.2

Red Hat linux 6

Hi,

I am following

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

to setup materialized view for 53 tables. I would link 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.

Regards,

Robbeen

This post has been answered by AndrewSayer on Jan 20 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2018

Added on Jan 15 2018

#general-database-discussions

21 comments

2,892 views