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