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

From: Thomas Day <>
Date: Thu, 31 Jul 2008 13:15:47 -0400
Message-ID: <>

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 - 12:15:47 CDT

Original text of this message