Read the manuals about snapshots/materialized views and about what is needed on their master tables to perform fast refresh.