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
- Follow-Ups:
- References:
Other related posts:
- » 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?
- » 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?
- » 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?
- » 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?
- » 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?
- » 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?
- » Re: MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?
> 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) ?