Re: MV logs with Oracle's auto extent control

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.

Other related posts: