Re: adop cutover

Posted by ErmanArslansOracleBlog on Dec 28, 2016; 2:34pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adop-cutover-tp1817p1818.html

Hi Linda,

Thank you . Happy New Year to you too:)

1)How did you drop the MV? Which command? I m asking this because Online Patching enabled MVs are built on top of the following;

an ordinary view called MV_NAME||'#'.
an MV implementation using  AD_ZD_MVIEW.UPGRADE

So, after you drop the MV, did you check with "sqlplus <apps_user> @ADZDSHOWMV <MV_NAME>"?

2)When did you drop the MV?

Because there is warning about the cleanup phase ...  Here;
Do not drop an obsolete materialized view until the cleanup phase of patch execution.

Additional Info:
 I looked at the AD_ZD_MVIEW.DROP_MV and saw the following comment there;

 DROP_MV                                                        |
  |                                                                |
  |   - Drops the given materialized view and its logical view     |
  |     If Running in PATCH edition                                |
  |         Stores deferred DDL to drop MV in next CLEANUP         |
  |     If running in RUN edition                                  |
  |         Drops MV immediately                                   |
  |