Re: large matview log, does it lock base table when dropping?

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.

--
http://www.freelists.org/webpage/oracle-l