Hi,
I get a ORA_12015 error when trying to create a view. I am using Oracle 8.1.7 EE on Windows 2000.
SQL> create materialized view testview
2 build immediate
3 refresh fast
4 enable query rewrite
5 as
6 select sum(actual) as sum_actual from test
7 /
select sum(actual) from test
*
ERROR at line 6:
ORA-12015: cannot create a fast refresh snapshot from a complex query
Thanks
Anurag