[Oracle-l] MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?

[Oracle-l] MODIFY Materialized View Definition without dropping it (or the MLog) after base table alter?

	Jared Still
	Nov 28, 2006 at 9:24 pm

On 11/28/06, Freeman, Donald 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

Search Discussions

Jared Still: Chris hasn't said why avoiding a replace of the MView was important, but I'm guessing it was to avoid the full refresh. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l

Follow ups

Alberto Dell'Era: 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
Jared Still: You can add the new column, but it will not be populated. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l
Freeman, Donald: Yep, I believe you are right but I found a reference to that syntax used by Arup Nanda on OTN . I'm going to skip ahead just drop the mv and rebuild in about five minutes. -----Original Message----- From: Jared Still 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 wrote: I was just planning on running create

Discussion Navigation

view	thread \| post
posts	‹ prev \| 5 of 13 \| next ›

Discussion Overview

font	variable	Hotkey: f
user style	avatars	Hotkey: a