Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized View Question
<amerar_at_iwc.net> wrote in message
news:1147444852.923919.82480_at_g10g2000cwb.googlegroups.com...
> But why create that additional table? Does that not double the space
> used?
>
> Also, I've noticed that if I change a columns length, I also need to
> change that local table before the refresh.
>
That's what a "materialized" view is; a copy of the data from a query. And yes, you need to reserve the necessary diskspace for them. Received on Fri May 12 2006 - 11:32:37 CDT