Freeman Robert - IL wrote: >Ok... I'm trying to build an MView that will fast refresh (on commit would >be nice but it's not required). Looking at the Oracle documentation, it >seems this should be ok, but I keep getting this error: > >ORA-12015: cannot create a fast refresh materialized view from a complex >query > > > Methinks that the problem is the aggregate. To refresh the aggregate properly from the logs you would have to execute some fairly complex operations. HTH SF ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------