This discussion is archived
3 Replies Latest reply: Apr 9, 2013 2:12 AM by 960075 RSS

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

960075 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points