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

From: Dan Norris <>
Date: Thu, 31 Jul 2008 13:19:55 -0500
Message-ID: <>


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.


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.
-- Received on Thu Jul 31 2008 - 13:19:55 CDT

Original text of this message