Re: Remote Materialized View containing joins

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 22 May 2009 20:09:13 -0700
Message-ID: <bf46380905222009t90a770bh8fa8f702afa66ca1_at_mail.gmail.com>

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
> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 22 2009 - 22:09:13 CDT