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

  • From: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • To: Thomas Day <tomdaytwo@xxxxxxxxx>
  • Date: Thu, 31 Jul 2008 13:19:55 -0500

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.
-- //www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2008