Re: reclaiming wasted space in Oracle

W dniu czwartek, 15 maja 2014 01:52:46 UTC+2 użytkownik Mladen Gogala napisał:
> On Wed, 14 May 2014 14:46:20 -0700, Mark D Powell wrote:
>
>
>
>
>
> > If you issue "alter table owner.t_1 move;" then Oracle by default
>
> > performs the move the table's assigned tablespace. The same is true on
>
> > an index rebuild.
>
> >
>
> > HTH -- Mark D Powell --
>
>
>
> Also, there is a command "ALTER TABLE SHRINK SPACE" which can shrink
>
> unused space in the table. That command should not be confused with the
>
> TRUNCATE TABLE command, which also shrinks space in the table. There are
>
> subtle but significant differences between the two commands.
>
>
>
>
>
>
>
> --
>
> Mladen Gogala
>
> The Oracle Whisperer
>
> http://mgogala.byethost5.com

ok, thanks :) Received on Thu May 15 2014 - 11:39:47 CEST