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
|
