Mladen Gogala wrote: >>This statement is too bold to be true, you'd find opposite in the Data >>Warehouse guide. :) > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#574693 > > Restrictions on Fast Refresh on Materialized Views with Joins Only Mladen, you won't find any joins in the original poster's question. -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- //www.freelists.org/webpage/oracle-l