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

From: Dan Norris <dannorris_at_dannorris.com>
Date: Thu, 31 Jul 2008 13:19:55 -0500
Message-ID: <4892024B.9040803@dannorris.com>

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