Materialized view - reading from another view , possible ?

Hi All,

Is it possible to create a materialized view where certain colums are coming from a number of base tables and few from an existing view.

for e.g
here monthly_sales is a view

create materialized view mv_test
 enable query rewrite
 build immediate
 refresh fast
 start with sysdate
 next sysdate + 1
 as
   select e.deptno, sum(e.sal) sal, sum(v.monthly_sales)    from emp e, v_monthly_sale v
   where e.emp_id = v.emp_id
   group by deptno;

Also I have read that in order to do fast refresh I need to create a log file. How would the create materialized log command look in this case ? Received on Thu Jan 29 2004 - 10:09:45 CST