FAQ
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 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

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 8 of 13 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 28, '06 at 5:05p
activeNov 30, '06 at 6:40p
posts13
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase