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

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: alberto.dellera@xxxxxxxxx
  • Date: Tue, 28 Nov 2006 14:26:05 -0800

On 11/28/06, Alberto Dell'Era <alberto.dellera@xxxxxxxxx> 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

Other related posts: