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

["Thomas Day" <tomdaytwo@xxxxxxxxx>]

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.

• Follow-Ups:
  • Re: large matview log, does it lock base table when dropping?
    • From: Dan Norris

• References:
  • large matview log, does it lock base table when dropping?
    • From: Dan Norris

Other related posts:

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

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

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

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

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