-
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
-
Investigate
Hi, 1st June 2001 12:50 hrs chennai
ORA-12015: cannot create a fast refresh snapshot from a complex query
Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries.
Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple snapshot.
As per oracle Error message information.
Give a try and back to this thread.
Cheers
Padmam