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

There's actually 100G of data in it (the table changes a lot and this has been capturing a month's worth of data), so I'm not sure there's anything that can be shrunk at this point.

Thanks for the tip, though, I think that may come in handy for some other logs at some point.

Dan

Thomas Day wrote:
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

Other related posts: