On Fri, May 22, 2009 at 1:16 PM, Xu, Roger <Roger.Xu@xxxxxxxx> wrote: > I finally created the MView and a function called MY_MV_CAPABILITIES per > http://www.sqlsnippets.com/en/topic-12884.html > > But it says “Not Capable of: REFRESH_COMPLETE” – how can that be? > > So, what's the error when you try to create with fast refresh? Is the SQL query using a rowid from each table? Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist