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: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: Tue, 28 Nov 2006 22:31:22 +0100
Message-ID: <4ef2fbf50611281331qd43e369udef4a9f27a9bc246@mail.gmail.com>


> 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-l
Received on Tue Nov 28 2006 - 15:31:22 CST

Original text of this message

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