Hi list. I have a problem with two layers of snapshots.

I have a set of tables. on this tables I have a set of snapshots (1:1,
created with select *, fast refresh on demand, on another machine).

I need another set of snapshots, created as joins on snapshots from
first set, also fast refresh on demand.
My problem is that all my tries result in "cannot fast refresh
materialized view....".
I'm able to create just COMPLETE refresh snapshots. please, if you
could,
give me an example, or a link to such an example, or any hints to build
such snapshots based on joins on another snapshots. And, it's a must,
fast refresh.


Regards,
Dan.


Oracle LazyDBA home page