Re: Nested Materialized View Refresh
From: ddf <oratune_at_msn.com>
Date: Sat, 13 Jun 2009 15:08:05 -0700 (PDT)
Message-ID: <22064e52-ef72-4c19-862b-a0263967faff_at_w40g2000yqd.googlegroups.com>
On Jun 13, 12:06 pm, Murty <m_ad..._at_hotmail.com> wrote:
> Thanks David!
> I don't find this restriction (that nested MVs shouldn't span across
> DB Servers) in the documentation.
> Secondly, if this is the expected behaviour, I thought it should
> return an error when the parent MV is on a remote server.
Date: Sat, 13 Jun 2009 15:08:05 -0700 (PDT)
Message-ID: <22064e52-ef72-4c19-862b-a0263967faff_at_w40g2000yqd.googlegroups.com>
On Jun 13, 12:06 pm, Murty <m_ad..._at_hotmail.com> wrote:
> Thanks David!
> I don't find this restriction (that nested MVs shouldn't span across
> DB Servers) in the documentation.
> Secondly, if this is the expected behaviour, I thought it should
> return an error when the parent MV is on a remote server.
There is no 'parent' materialized view in your example, since they aren't nested, which is why the NESTED=>TRUE does nothing in your case. Since there is no parent MV what possible error could be returned? Again, the dependency tree for true nested materialized views doesn't span servers; you have a source MV, not a parent.
David Fitzjarrell Received on Sat Jun 13 2009 - 17:08:05 CDT