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: Chris Marquez <marquezemail_at_gmail.com>
Date: Thu, 30 Nov 2006 13:40:51 -0500
Message-ID: <d494e9760611301040r6d259b78me2da755831d8ad56@mail.gmail.com> 





All,



Thanks all for the comments and ideas.



It appears that this is still not simple in Oracle.



I have a (long) plan to ALTER and RECREATE *things*.



Jared was right...I need the new columns on both places and wanted to avoid
the MV re-create and full refresh.  That's because of the object type, size
and dependencies;


MVIEW



CLOB



CONTEXT INDEXES.




-- 



Chris Marquez


Oracle DBA



--



http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 30 2006 - 12:40:51 CST












Original text of this message













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