SQL Language (MOSC)

MOSC Banner

Alter materialized view - how to remove the start with ?

edited Jul 12, 2012 9:53AM in SQL Language (MOSC) 5 comments
 Hello,
I own a set of views that I want altered.

They are all defined as follows:

CREATE materialized VIEW my_view01
build deferred
refresh force ON demand
start WITH to_date('12-07-2012 23:59:00', 'dd-mm-yyyy hh24:mi:ss') next to_date(TO_CHAR(SysDate,   'ddmmyyyy')||'23:59','ddmmyyyy hh24:mi')   
AS
SELECT ... FROM ...

I wish to alter to the following definition:


CREATE MATERIALIZED VIEW  my_view01
BUILD DEFERRED                                                 
REFRESH COMPLETE
ON DEMAND
AS
SELECT ... FROM ...

I was told to drop, but each views have grants, synonyms,  index that I do not want to recreate.

So my question how the alter materialized view for the new definition?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center