On 10/5/07, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> 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.