Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?

Re: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 28 Nov 2006 17:33:44 -0800
Message-ID: <bf46380611281733y3f8e0056i7db5d2be8be1d51d@mail.gmail.com>


On 11/28/06, Alberto Dell'Era <alberto.dellera_at_gmail.com> wrote:
>
> I think there's a misunderstanding here, I was just asking to Chris
> whether the new column, that has to be added on the base table,
> possibly with a default value, has to be propagated to the MV also (so
> with the same value) or not.
>
> Eg
> old mv : create materialized view as select a from t_at_dblink
> say you "alter table t add (new_column int default 42)"
> has the mv to be logically modified to
> create materialized view as select a, new_column from t_at_dblink
> or does it stay the same, ignoring new_column ?
>
>

Ah, I see.

If that were the case, there's little else to do.

Adding a column to the table does not invalidate any of the objects used for the materialized view, and it will still work properly.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 28 2006 - 19:33:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US