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

On 11/28/06, Alberto Dell'Era <alberto.dellera_at_gmail.com> wrote:
>
> > I need to alter my base table (add columns) and thus also the remote db
> > MView referring to it.
>
> But do the new columns need to be added to the remote MV also -
> and if yes, will they have the same value - ie is it something
> like
>
> add (new_col default new_val) ?

You can add the new column, but it will not be populated.

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

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