Re: Materialized View Question

From: Jack <none_at_INVALIDmail.com>
Date: Fri, 12 May 2006 14:27:24 GMT
Message-ID: <gX09g.229$nC3.105@read3.inet.fi>

Hi!

Materialized views are supposed work in that way. Maybe you want to use plain view instead?

<amerar_at_iwc.net> wrote in message
news:1147442938.241592.64710_at_i40g2000cwc.googlegroups.com...
> Hi Everyone,
>
> I'm showing my ignorance here. But, when we create a materialized
> view in one schema that is off of a table in another schema, it not
> only creates the materialized view, but it also creates a local table.
>
> I'm unclear why. The source table is in another schema, why create a
> copy of the table in the current schema where the view is located??
>
> Thanks in advance!
>
Received on Fri May 12 2006 - 09:27:24 CDT