Re: large matview log, does it lock base table when dropping?
Date: Thu, 31 Jul 2008 13:15:47 -0400
Have you tried
alter materialized view log on *master* enable row movement;
alter materialized view log on *master* shrink size;
This is supposed to be very DML friendly. I haven't tested it for locks but it's supposed to only have row locks on data in the log. It could take a while for 100G though.Received on Thu Jul 31 2008 - 12:15:47 CDT