Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reusing free space in a table

Re: Reusing free space in a table

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Fri, 24 Sep 1999 09:05:19 -0400
Message-ID: <37EB770F.6FD9A167@Unforgettable.com>


I used to think that "ALTER TABLE XXXX DEALLOCATE UNUSED" was supposed to=

correct this, but I've never seen it work the way I expected. Does anyone=

else have experience on this?

"Xavi Gabaldą" wrote:
> =

> Hi:
> =

> I have a tablespace of 5 Gbytes. It has 10 datafiles of 500 Mbytes ( No=

> autoextend ). I have 1 table of 4.5 Gbytes. This table has a lot of ext=
ends.
> I have deleted 1 Gbyte of this table but Oracle seems not to reuse this=

> space.
> =

> Is this 'normal' in Oracle ?
> Why ?
> Is there any command to reallocate free space of deleted rows ?
> =

> Note: I want to avoid the classic way... ( I have 3.5 Gbytes in the tab=
le
> ! )
> =

> 1) Export data
> 2) Drop table
> 3) Create table
> 4) Import data
Received on Fri Sep 24 1999 - 08:05:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US