Re: How to resize initial extent of a table?

Did you use the full 'deallocate' syntax - if you want to reduce the initial extent you have to specify the amount of space
above the high water mark that you want
to keep - e.g.

alter table xxx deallocate unused keep 1M;

If you omit the KEEP clause, then you only release space above MINEXTENTS.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Chris Neubauer wrote in message <9ommug$e99ge$1_at_ID-76747.news.dfncis.de>...


>Hi,

>

>I said 'would you please import the database' ... and our DBAs did it. But

>when I had a look, I frowned: Each table consisted of one single extent,

>several have a size of 2 GB. Ok, after my first cleanup the Table is only

>200 MB large, but the Extent of 2 GB remains.

>

>How can I shrink the initial extent of my table, without re-importing the

>complete database? I tried 'alter table ... deallocate unused', but it did

>not work as expected ... are there any tricks?

>

>Regards,

>Sebastian

>

>