3 Replies Latest reply: Apr 9, 2013 4:18 AM by spajdy RSS

    If you drop a MV log then do you have to recreate the MV?

    960075
      If you drop a MV log then do you have to recreate the MV in order for the MV to work again. i.e.

      -- I create MV log and MV (10 second refresh) on 2 different DB machines
      -- I drop the MV Log
      -- MV will not get refreshed
      -- I recreate the MV log

      Now will the MV get refreshed as usual or do I have to recreate it?

      Edited by: 957072 on Apr 8, 2013 2:54 AM

      Edited by: 957072 on Apr 8, 2013 2:55 AM