Re: You cant resize the initial extent

From David P.

Thanks Jonathan - didn't realise Oracle would be able to handle a HWM within e.g. the initial extent. This would seem to solve the original problem well.

Jonathan Lewis wrote:
>
> Have a look at (v7.3+)
> alter table deallocate unused.
>
> You can drop the size right down to the
> high water mark, even if this takes you
> below minextents and below the initial_extent
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> DNP wrote in message <38C6BF72.4E0E_at_btinternet.com>...
> >(Comments below may not apply to Oracle 8i / 8.1.5 (6) )
> >
 

> >You can't resize the initial extent once the object has been created
> >(nor any other extents starting below the High Water Mark).
> >
  Received on Thu Mar 09 2000 - 00:00:00 CST