On 10/5/07, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
>
> A Truncate doesn't actually do a "drop and recreate". It drops all
> extents *after* the first one.
> Apparently, your first extent for those MVLog Tables has been
> 8MB. Why ? Not sure yet.
> But here's a suggestion. Try dropping and recreating the MV logs.
> (DROP SNAPSHOT LOG ON TABLE <tablename> ; followed by the CREATE
> SNAPSHOT LOG ... )
Yes, that will work; however, we're doing the refresh once an hour. We have
a lot of mv logs. I'd prefer to keep them in place if I can.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 05 2007 - 11:59:35 CDT
