Materialized view - reading from another view , possible ?

Giganews Newsgroups
Subject: Materialized view - reading from another view , possible ?
Posted by:  manish…@hotmail.com
Date: 29 Jan 2004

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 ?

Replies