Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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) ?
-- Alberto Dell'Era "Per aspera ad astra" -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 28 2006 - 15:31:22 CST
![]() |
![]() |