Re: Remote Materialized View containing joins
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Roger.Xu@xxxxxxxx
- Date: Fri, 22 May 2009 20:09:13 -0700
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
Other related posts:
