Re: resizing initial extent downwards
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 28 Nov 2000 20:34:15 -0000
Message-ID: <975439977.23311.3.nnrp-09.9e984b29_at_news.demon.co.uk>
Date: Tue, 28 Nov 2000 20:34:15 -0000
Message-ID: <975439977.23311.3.nnrp-09.9e984b29_at_news.demon.co.uk>
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 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 <3A2353B4.E11B7FDA_at_adelaide.edu.au>...Received on Tue Nov 28 2000 - 21:34:15 CET
>What we'd like to do is delete 90% of a table (where the initial extent
>has been extended to take up the whole table ie. 250Mb), and reclaim
>that space.
>
>We initially thought that by exporting the table and re-importing it,
>the initial
>extent would be set to the actual size of the table. It doesn't though,
>it keeps it at 250Mb, where the data now only needs 20Mb as an initial
>extent.
>
>We are doing this same process for some 200+ tables so a generic
>solution would be best.
>
>Any ideas?
>
>
>Thanks
>
>Steve
>