Re: You cant resize the initial extent

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).

>