Re: How to resize initial extent of a table?

"Chris Neubauer" <water.world_at_gmx.de> wrote in news:9ommug$e99ge$1_at_ID-76747.news.dfncis.de:

> Hi,
>
> 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?

First of all, I would hope your DBA would understand how to do this. If your DB version is 8.1.6 or higher, you can execute: alter table ... move ... storage(...) tablespace same_tablespace;

If your 8.1.5 or lower, and the table is a partition you can do something similar to the above, but if not. Export and import just that table.
>
> Regards,
> Sebastian
>
>
>

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com