Re: resizing initial extent downwards

BTW -
That should have read:

    'space above the high-water mark'

NOT
    'space below the high-water mark'

Nothing 'frees' space below the high-water mark - only space betwen the high-water
mark and the end of extent can be freed.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Steve Salvemini wrote in message <3A2443FF.BDDDAEA5_at_adelaide.edu.au>...


>Thanks guys for the great response, Jonathan's solution has proved to be

>our best option.

>

>for the record:-

>

>this was out case:

>before delete: initial = 250Mb

>after  reimport: initial = 250Mb

>alter table xxx deallocate unused keep 16k

>after alter: initial = 1.5Mb

>

>so its upsized to initial to fit the entire table into the initial

>extent.

>

>From here we will generate a script to run this alter on all tables

>within a tablespace.

>

>----------------------

>

>Alter table XXX deallocate unused keep 20M;

>

>Not sure which version of Oracle this first

>appeared in.  7.3.late I think.

>

>This frees up space below the high water mark -

>of which there should be lots if you've just

>re-imported the table.

>

>--

>Jonathan Lewis

>