Database DataWarehousing (MOSC)

MOSC Banner

A Materialized View Rebuild Built-in?

edited Dec 20, 2013 6:20AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓
Is there a built in process to rebuild a materialzed view as opposed to refreshing the MV? 

I can use the following to refresh an MV, but cannot find a reference to one to rebuild the MV if the underlying structure has changed.  In my case it is a single table

     DBMS_MVIEW.REFRESH('<materialized view name>');

Or, do I need to drop the MV and use the create statement to rebuild it?

thanks

Alan

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