Re: How to deallocate inital extents from locally managed tablespace

Well, this is works but seems strange to me.........

alter table x deallocate unused;

Does nothing....still 128 extents. This command is supposed to deallocate everything above the high water mark.

alter table x deallocate unused keep 1k;

This works. It reduces the table down to 1 extent of 8k. This command deallocates down to the HWM and will release extents above the table's MINEXTENTS. I find this strange, because the table's MINEXTENTS is 1 after it is initially created........

Oh well. At least I don't have to write the script to pre-create every table before doing an import.

r_bauza_at_yahoo.com (rjb) wrote in message news:<772c2243.0203202321.6c7c49a4_at_posting.google.com>...
> How can you deallocate unused initial extents from a table created in
> a locally managed tablespace?
>
> For example: I have a LMT "new_tbs" with uniform extent size of 8k.
>
> Create table x(a number) storage (initial 1M) tablespace new_tbs;
>
> That gives me a table with 128 extents with no data in it.
>
> alter table x deallocate unused; does nothing....still 128 extents.
>
> truncate table x; does nothing....still 128 extents.
>
> Is there a way to get this thing down to 1 8k extent without dropping
> and re-creating with a different storage clause? (This is related to
> using import).
>
> Thanks in advance.
Received on Thu Mar 21 2002 - 13:40:30 CST