Re: Remote Materialized View containing joins
Date: Fri, 22 May 2009 20:09:13 -0700
On Fri, May 22, 2009 at 1:16 PM, Xu, Roger <Roger.Xu_at_dpsg.com> wrote:
> I finally created the MView and a function called MY_MV_CAPABILITIES per
> 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?
Certifiable Oracle DBA and Part Time Perl Evangelist