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

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Tue, 28 Nov 2006 17:28:41 -0500
Message-ID: <51327ABA927BEF4B96590554CEA7832C2907D3@enhbgpri05.backup>

Yep, I believe you are right but I found a reference to that syntax used by Arup Nanda on OTN <g>. I'm going to skip ahead just drop the mv and rebuild in about five minutes.

	-----Original Message-----
	From: Jared Still [mailto:jkstill_at_gmail.com] 
	Sent: Tuesday, November 28, 2006 4:25 PM
	To: Freeman, Donald
	Cc: marquezemail_at_gmail.com; oracle-l
	Subject: Re: MODIFY Materialized View Definition without

dropping it (or the MLog) after base table alter?                  

        On 11/28/06, Freeman, Donald <dofreeman_at_state.pa.us> wrote:         

                  I was just planning on running create or replace mview as select * from source;                                  

        create or replace materialized view?         

        That works on view, but not on MV's.         

	-- 
	Jared Still
	Certifiable Oracle DBA and Part Time Perl Evangelist 
	

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 28 2006 - 16:28:41 CST