A Materialized View Rebuild Built-in?
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
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
0