Can materialized views be used as a fast denomalized big table?

Question

Can Oracle Materialized views be used to join multiple related tables having foreign keys to create a larger denormalized big table which is refreshed instantaneously?

On some investigations, it says that joins are not allowed while using fast refresh.

Is it my assumption which is wrong that i can do this sort of thing with Oracle Materalized views?

Answer 1

Assuming all the tables are local (i.e. you are not trying to replicate the data from a remote database and do the joins all in one step), the restrictions you need to be aware of are listed in the Data Warehousing Guide, not the replication manual. The specific set of restrictions depends on the Oracle version but you should be able to create a fast-refreshable denormalized view of your data.